How you load distinct records into one target and duplicate
records into another target?
- 3 Answers
- 15790 Views
- Mphasis, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / moorthy. g
S-SQ-Exp-Rtr-Tgt1/Tgt2
Exp:
flag: decode(true, col1=prev_col1,'Y','N')
pre_col1=col1;
Rtr:
Group1 --- flag='Y' --- Tgt1 -- Duplicate Values
Group2 --- flag='N' --- Tgt2 -- Unique Values
Best Regards,
Manthiramoorthy. G
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / hema
With an Expression transformation flag the 1st record of a
group with some value say "VALID" and flag the other
records of the same group with value say "DUPLICATES". Then
pass this through a router and then to the different
Targets.(1st target - records with VALID flag and in 2nd
target - records with "DUPLICATES" flag)
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / shaik
Create a mapping with two targets.
> Create an Aggregator transformation and group it on the
distinct values and load it into Target1.
> Load the data directly in to Target2 since the source
have duplicates it will load all the duplicates.
| Is This Answer Correct ? | 5 Yes | 3 No |
Explain reference cursor?
Describe data concatenation?
What are the limitations of joiner transformation?
Explain about perform recovery?
What are the different types of Type2 dimension maping?
How to read data from flat file source if the data is in paragraph format?
What is the filename which you need to configure in UNIX while installing infromatica?
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
What is a transaction control transformation?
how can import the data from the flat files?
what is the significance of newlookup port in dynamic look up
what is diff b/t sorter t/r and agg have the option sorter property...
Teradata 
