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
- 14938 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
What is enterprise data warehousing?
What is the function of aggregator transformation?
What is session task and command task?
What are active transformations.
What is a transaction control transformation?
Informatica settings are available in which file?
How to improve the performance of a session using sorter transformation?
How to extract sap data using informatica?
What are the mapping parameters and mapping variables?
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?
what is INFORMATICA TESTING process
complex mapping ur project u r invlve can u explain and give real time example give me ?
What is the reusable transformation?
How can we use mapping variables in informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
