suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping?how
Answers were Sorted based on User's Feedback
Answer / leo gilbert
Have a lookup to table T1 (should be dynamic one). If the
record already exists in T1 (i.e. duplicate) then route to
T2 else route to T1
|Is This Answer Correct ?||9 Yes||0 No|
Answer / vivekk
Src-->SQ-->AGG-->RTR--->TG1 & TG2
In AGG Txn, take count(columns), then pass this port to RTR Txn which has Unique and Duplicate group. Unique group will be having condition count = 1 whereas for Duplicate group has condition count > 1. Pass these to TGT instance 1 and 2.
|Is This Answer Correct ?||1 Yes||0 No|
Answer / laksh
You can do this in one mapping by using sorter and then
expression transofrmation ..in Expression use 3 variables ..
1 Current 2 previous 3 route..
if prevous = current sent to table 2 else 1.
|Is This Answer Correct ?||2 Yes||2 No|
Answer / balaramesh
using constraint based transformation
|Is This Answer Correct ?||1 Yes||5 No|
have u done any performance tuning? how u ll do?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
What is confirmed dimension and fact?
How do you join more than 3 flat files in informatica?
What are the different threads in DTM process?
What are the options in the target session of update strategy transsformatioin?
What is the meaning of decode in informatica?
source is a flat file empname, empno, sal ram, 101, 1,000 sam, 102, 2,000 ques: my target needs the data to be loaded as sal -1000 and 2000 excluding commas target empname, empno, sal ram, 101, 1000 sam, 102, 2000 how to implement this?
i have two sources two flatfiles same structure one flatfile contain 100 million recs another flatfile contain 10 million recs i have to connect single target(performance oriented answer) what are the steps we have to do this scenario
how do the project develops? pls specify right from the start to end in step by steps.
task is running successfully but data is not loded why?