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
- 41690 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 diff b/t sorter t/r and agg have the option sorter property...
What are the advantages of informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Plz can any one say me how to get the informatica certification materials and dumps
Explain the informatica workflow?
What is the benefit of partitioning a session?
In development project what is the process to follow for an etl developer from day1
Explain pushdown optimization and types in informatica
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the different types of olap? Give an example?
What is the need of an ETL tool?
Why is sorter an active transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How can you increase the performance in joiner transformation?
How do you load only null records into target?
