How you load distinct records into one target and duplicate
records into another target?
- 3 Answers
- 15126 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 |
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
How many ways a relational source definition can be updated and what are they?
i have source data like id name sal 1 a 65020 2 b 78250 3 c 58264 but how to get target like this id name sal 1 a Sixty five thousand twenty 2 b Seventy thousand two fify 3 c Fifty eight thousand two sixty four
what is constraint based loading
differences between service based and product based?
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
how to run 2 workflows sequentially. plz respond what is the process?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
How do you handle two sessions in Informatica
How to recover sessions in concurrent batches?
What is the function of look up transformation?
ONE FLAT FILE IS THERE WHICH IS COMMA DALAMETED . HOW TO CHANGE THAT COMMA DELEMITER TO ANY OTHER AT THE TIME OF RUNNING ?
Teradata 
