IT Pandora (ETL,DB,UNIX,AWS,NodeJS,Github etc.)

We will be having a dilemma that when should we go for  dynamic lookup so let us discuss about that first. When we create a lookup on a target table and we are sure that there will be no duplicates coming from source data on PK Combination we go for a static cache lookup. But when there are duplicates coming from source end and we need to pick a latest value from the set then we go for dynamic look up. let me brief you with an example data Name   Location AAA    IND BBB     USA CCC     EUR AAA    EUR suppose we have data in the above following manner and only latest records should be pulled into the target so that the target data should look like in the following manner Name Location AAA  EUR BBB   USA CCC   EUR When we select dynamic cache in look up properties a new column named as NewLookupRow gets added in ports section of look up. Then we need select Insert else Update and Update else insert option. The Newlook up row when the value returns as 0 means the

After a bit of gap, i am back here.So instead discussing about a specific topic, let me tell you about some tricks/tips that can be used while working in informatica Worklet as we know is a set of reusable tasks.We cannot start a single task individually in worklet from workflow manager. we need to run the worklet in order the start the individual tasks assigned to it.Although after a run in completed from workflow monitor we can start tasks individually from monitor. If a worklfow which has schedule assigned to it gets failed, then it gets unscheduled so we need to reschedule it again by doing right click in workflow manger and select schedule workflow. If the following error appears while trying logging in informatica   Then try restarting services by doing the following steps go to run and type services.msc, there search for informatica sever then right click select restart.   Joiner vs lookup - It is advisable to choose joiner transformation when there are large