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
- 14933 Views
- Emirates, IBM, I also Faced
- E-Mail Answers
Answer Posted / abhishek upadhyay
It can be done easily by a SQ generator....The SQ generator
will assign the number as a PK to all the rows.
1
2
3
4
5.... and so on
Now when this is done you can write in the post target sql
that -
delete from target table where number <>1 or number <> 5
and then the target table will be left with only 1 and 5
records
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you promote a non-reusable transformation to reusable transformation?
Differentiate between sessions and batches?
How do you set a varible in incremental aggregation
What if the source is a flat-file?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
how to load dimension table and fact table. plz tell me the steps.
What is main use of mapplet?
What are the measure objects?
What is a grid in Informatica?
How are the sources and targets definitions imported in informatica designer?
What are session parameters ? How do you set them?
can anyone explain me about retail domain project in informatica?
What is the use of transformation?
How to generate sequence numbers?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
