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 a repository? And how to add it in an informatica client?
What are the types of schemas we have in data warehouse.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What do you mean by channel change?
What are the guidelines to be followed while using union transformation?
tell me 5 session failure in real time how can you solve that in your project?
What is the advantage of informatica?
What is the difference between STOP and ABORT options in Workflow Monitor?
Is there any way to read the ms excel datas directly into informatica?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What is informatica worklet?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain lookup transformation is active in informatica
What does update strategy mean, and what are the different option of it?
Can you use flat files in Mapplets.