Interested to Buy Any Domain ? << Click Here >> for more details...
How you load distinct records into one target and duplicate
records into another target?
- 3 Answers
- 16637 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 plsql table?
Explain what are the different versions of informatica?
Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.
What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
Difference between session variables and workflow variables?
how do the project develops? pls specify right from the start to end in step by steps.
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
What do you understand by a term domain?
how to call lookup qualifer in unconnected look;up
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
Teradata 
