What is the method of seperating unique and duplicate
records in session level?
- 2 Answers
- 9715 Views
- Emphasis, JBL, Wipro, I also Faced
- E-Mail Answers
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 |
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
What is an aggregator transformation?
How we will implement Pushdown Optimization and Types in Informatica with better examples
What is the need for an etl tool?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
What is meant by active and passive transformation?
How do you recover rows from a failed session
What happens if the info. Server doesn't find the session parameter in the parameter file?
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
what is the dashbords?
Teradata 
