Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 10 Answers
- 15298 Views
- Emirates, IBM, I also Faced
- E-Mail Answers
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
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Briefly explain the aggregator 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?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What could be the possible resons of locks by user?
What is the advantage of informatica?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is a joiner transformation and why it is an active one?
What are the differences between joiner transformation and source qualifier transformation?
What is enterprise data warehousing?
What is target load order?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the difference between a repository server and a powerhouse?
Different circumstance which drives informatica server to expel records?
what is the hint? how to use it to reduce the query processing in program?
