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
- 15344 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
Under which circumstances, informatica server creates reject files?
What is informatica etl tool?
What are the tuning techniques you applied during your last project
What is exclusive and normal mode for repository services?
What is the meaning of decode in informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
How do you load only null records into target?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Briefly describe lookup transformation?
how to load rows into fact table in data warehouse
what is diff b/t sorter t/r and agg have the option sorter property...
wf dont have integration severances how you can run?
What are the differences between source qualifier and joiner transformation?
What are mapplets?
How many numbers of sessions can one group in batches?
