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
- 12357 Views
- Cognizant, HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can we delete duplicate rows from flat files?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is session task and command task?
Is there any target staging area in informatica not staging area
How to configure mapping in informatica?
What are the different options available for update strategy?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain pushdown optimization and types in informatica
Explain how many types of dimensions are available in informatica?
How do you remove duplicate records in informatica? And how many ways are there to do it?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is rank transform?
can you please explain me pre session and post session options?
What is decode in informatica?
Explain sessions and how many types of sessions are there?
