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
- 40818 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
How to improve the performance of a session using sorter transformation?
What is the use of code page?
What are the tuning techniques you applied during your last project
Define enterprise data warehousing?
Design a mapping to load a target table with the following values from the above source?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is the maplet?
What are active transformations.
What is a joiner transformation?
How is union transformation utilized?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the different options available for update strategy?
Name the different lookup cache(s)?
What are junk dimensions?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
