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
r u done any partitions in ur project?
How can we use batches?
What are the modules in Power Center
How does a sorter cache works?
What are the new features of informatica 9.x at the developer level?
Slowly changing dimensions, types and where will you use them
Differences between connected and unconnected lookup?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is data transformation manager process?
what is mean by complex business rule ?
How can you define user defied event?
What is joiner transformation?
What is meant by active and passive transformation?
What is rank transformation?
Different circumstance which drives informatica server to expel records?