how to load only the first and last record of a flat file
into the target?
Answer Posted / bsgsr
first record can be loaded using the top and only one rank
in ranker transformation.
the last record using aggregator without group by option.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
How to update or delete the rows in a target, which do not have key fields?
What is informatica? Why do we need it?
lookup transformation with screenshots
Explain the etl program with few examples.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
Explain in detail scd type 2 through mapping.
How to improve the performance of a session using sorter transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
What is data movement mode in Informatica and difference between them?
Can we create a node as a gateway node and the same node can be assigned to a grid?
How do you update the records with or without using update strategy?
How do you load alternate records into different tables through mapping flow?
How to elaborate powercenter integration service?
Briefly describe lookup transformation?
How do you load only null records into target? Explain through mapping flow.