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 / 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
What are active transformations.
What do you understand by SOA of Informatica?
tell me the rules and responsblites in our project(my project is development)
Explain load alternative records / rows into multiple targets - informatica
How does a sorter cache works?
What do you mean by channel change?
How to call shell scripts from informatica?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
Different sorts of metadata that stores in the storage facility?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How big was your fact table
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How can a transformation be made reusable?