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
- 41272 Views
- Deloitte, IBM, iGate, I also Faced
- E-Mail Answers
Answer Posted / hunny
Try This :
Source -> SQ -> Sorter(Sort by Ascending on Key) -> Aggregator(Group by key Column,var=count(key colmn) - > Router(var = 1) -> Unique Target and (var > 1 ) -> Duplicates.
Make sure the Datatype for Var is not String in this scenario else will encounter operands of ambigious types mismatch error.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is a sorter transformation?
What is meant by target load plan?
Clarify the aggregator change?
What is meant by query override?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Write the advantages of partitioning a session?
Define pmcmd command?
Can we get 1st record through Informatica(without sequence number).
What are the main features of Oracle 8i with context to datawarehouse?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
State the differences between sql override and lookup override?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Different qualification between a related rotate toward the sky and isolates look upward?
Write the program through which the records can be updated?
