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?
Answer Posted / abhishek kumar
my source record 100 loads into one group. because router
first check first group than after second conscecuently.
| Is This Answer Correct ? | 3 Yes | 11 No |
Post New Answer View All Answers
Mention a few design and development best practices for informatica?
How to generate sequence numbers without using the sequence generator transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
What are the tuning techniques you applied during your last project
Separate from an archive server and a powerhouse?
Can we create two repositories on same database instance in oracle?
During the running session, output files are created by informatica server. Enlist few of them.
Have you worked with/created Parameter file
Do you find any difficulty while working with flat files as source and target?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is Session and Batches?
Why filter transformation is an active one?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
whats the logic to load the lower level of granularity of data to fact table.
How to load last n records of file into target table - informatica