What is the method of seperating unique and duplicate
records in session level?
Answers were Sorted based on User's Feedback
Answer / jz
Select Distinct Box at Source propeties level or jus
override sql in Session.
Is This Answer Correct ? | 17 Yes | 3 No |
Answer / priya yadav
Hi,
I am not aware at session level but I can tell you the same
at mapping level.
Either Select Distinct in SQ itself or in expression, u can
use a variable v1 to store the business keys of the
records. This will store the business keys(based on which
you have to determine a record as duplicate) of the record
v1= A||B||C
Assign this to another variable v2. This will assign these
business keys to v2.
v2=v1( Now v2 will have value A||B||C)
Set Duplicate Flag as Y if V1= V2 else N.
Now the business keys are stored in v2. Next time the
record will come it will calculate v1 on basis of business
keys, if that record is duplicate v1=v2, and record will be
marked for duplicate. If the record has different business
keys then v1 <> v2, and the record will not be marked as
dupliacte.
Hope it helps.
Thankyou!!
Priya Yadav
Is This Answer Correct ? | 0 Yes | 0 No |
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
what is the method of error handling when session is running?
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
Are there any types of Dynamic Caches in informatica
What is informatica powercenter repository?
Differentiate between joiner and lookup transformation?
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
What is meta data and system catalog?
Define filter transformation?
What is different between informatica version 8 and 9 version
What is the use of code page?
How to delete first 3 rows & last 3 rows in target table in informatica