I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
Answer Posted / ashok
Sequence Generator
| Is This Answer Correct ? | 1 Yes | 7 No |
Post New Answer View All Answers
What is a code page?
To import the flat file definition into the designer where should the flat file be placed?
What is the use of source qualifier?
What do you understand by a term domain?
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.
What are the data movement modes in informatica?
Which files are created during the session rums by informatics server?
How to generate sequence numbers using expression transformation?
What is the use of target designer?
In how many ways we can create ports?
Explain joiner transformation in informatica
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is a connected transformation?
Make a note of the quantity vaults made in informatica?
Briefly explain the aggregator transformation?