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
- 15296 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
Tell me about MD5 functions in informatica
what is the complex transformation you used in informatica
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is meant by LDAP users?
How to update a particular record in target with out running whole workflow?
What is an aggregator transformation?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
how many types of dimensions are available in informatica?
generate date / time dimension in informatica
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to load the data from a flat file into the target where the source flat file name changes daily?
What does command task mean?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Differentiate between source qualifier and filter transformation?
