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
- 41246 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
What is a joiner transformation and why it is an active one?
Briefly define a session task?
What are the differences between a connected lookup and unconnected lookup?
How to create a non-reusable instance of reusable transformations?
whats the logic to load the lower level of granularity of data to fact table.
What all join we can perform in LOOKUP transformation?
What is a sequence generator transformation?
What is the commit type if you have a transaction control transformation in the mapping?
Which transformation is needed while using the Cobol sources as source definitions?
What does reusable transformation mean?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What you know about transaction control transformation?
Performance tuning( what you did in performance tuning)
What do you mean by blocking transformation?
What is target designer and target load order?
