What is a sequence generator transformation?
No Answer is Posted For this Question
Be the First to Post Answer
write a query for how to eliminate the duplicate rows without using distinct?
Describe the impact of several join conditions and join order in a joiner transformation?
Do you find any difficulty while working with flat files as source and target?
What is the difference between view and materialised view?
How the Informatica Server reads perameter file?
What is a command that used to run a batch?
difference between shortcut and reusable transformation?
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
How to use pmcmd utility command?
I have in my source Records like 100,101,102 etc. I have router transformation which has groups like one group is empno=100, second group is empno>99. Now i want to know my source record 100 loads into which group?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
Flat file heaving 1 lack records and I want to push 52000 records to the target?