i have to extract data from a flat file.the flat file has 10
records.i have to extract the 1st and 5th record every
time.how is it done.
Answer Posted / satya
after the SQ have EXPR t/r and add sequence to have unique
no's. add rank t/r get the ranks and have two filters one
for no=1 and other is for no=5 write them to the same target
hope this will address your scenario.
For more info reach me at satya.ylv@gmail.com
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What is the difference between writing a joiner query in ANSI style and THETA style?
Mention a few design and development best practices for informatica?
Where can we find the throughput option in informatica?
What are mapplets?
How big was your fact table
What is joiner transformation in informatica?
What are the types of caches in lookup?
Which transformation is needed while using the Cobol sources as source definitions?
What is a filter transformation?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the Rank index port in Rank transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How you can differentiate between connected lookup and unconnected lookup?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
How to load data in informatica ?