Interested to Buy Any Domain ? << Click Here >> for more details...
how to send unique records to one target and duplicate
records to another target by using dynamic lookup cache?????
please explain me briefly///(when we use this we look up on
which target unique target ya duplicate target)
- 3 Answers
- 12619 Views
- Cognizant, HP, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sarvesh
whenever we create dynamic lookup a default col gets added i.e. newlokuprow it has a defaul value 1 for insert that is newrow and 0 for delete or duplicate or same row which already exists. so just use router tr and separate the 0 value row will eliminate the duplicates.
| Is This Answer Correct ? | 9 Yes | 6 No |
Answer / harish konda
We know that Dynamic Look Up Cache returns 1 for insert and
2 for update. So connect the source to the lookup which is
Dynamic and in next in router create 2 conditions. Records
which new it will return 1 and records which are there it
returns 2.
| Is This Answer Correct ? | 4 Yes | 3 No |
Answer / dave
May be i understood question wrong , but :
For unique records you can use in Source Qualifier SQL with
having count condition = 1 to cut the unique records to one
target
And for second target same query but with >1 condition
---
| Is This Answer Correct ? | 2 Yes | 9 No |
What are the session parameters?
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 using aggregator & router? how
how can u load the data in time dimension?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
what are the types of facts with Examples?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
What is the difference between a table and the materialized view?
Which kind of index is preferred in DWH?
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
What are the types of data that passes between informatica server and stored procedure?
Teradata 
