How you load distinct records into one target and duplicate
records into another target?
- 3 Answers
- 15434 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 |
What is a sorter transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
what is dynamic cashe
What is data movement mode in Informatica and difference between them?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How to jion 2 tables, without using any condition?
what is polling?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
In which circumstances that informatica server creates Reject files?
What is difference macros and prompts?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
Teradata 
