Interested to Buy Any Domain ? << Click Here >> for more details...
How we can get unique records into one target table and
duplicate records into another target table??
- 11 Answers
- 41153 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / haaris
If the source is RDMS, then you can write analytic function in the select statement to assign count to each row. And use this count column to route the records to respective target.
If the source is a flat (this is generally asked in interviews), then you can use aggregator to assign count to each row after grouping based on the key and use joiner to join back to source records that way all the rows coming from the SQ will have respective counts. Use router to route them to respective targets.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Partition, what happens if the specified key range is shorter and longer
How can you increase the performance in joiner transformation?
How would you copy the content of one repository to another repository?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is the need of an ETL tool?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
what are the deliverables?in your project?
What is blocking transformation?
can anyone suggest best free Talend data integration training online
Differences between version 7.x and 8.x.
What you know about transaction control transformation?
Enlist the tasks for which source qualifier transformation is used.
What is meant by target load plan?
Explain what is informatica metadata and where is it stored?
Explain the code page compatibility?
