I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
No Answer is Posted For this Question
Be the First to Post Answer
How to load the source table into flat file target(with columns) in informatica?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
What is aggregate awareness?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?
What is an active transformation?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
2,if we have 3 pipeline containing 3 targets and each target is connected with diff sequence generator ,let us assume first target is populated with seq no1-9,so what would be the number generated by other two sequence generator?what is the diff in o/p if when we use reusable sequence generator?what would be the diff if we place expression in between target and sequence generator?
What is lookup change?
What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?
Name 4 output files that informatica server creates during session running?
how DTM buffer size and buffer block size are related
Briefly define reusable transformation?