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
- 12475 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 |
If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?
How many joins in Informatica
How to elaborate tracing level?
without dynamic lookup transformation how to insert new rows and update existing rows?
Why we use ENABLE HIGH PRECISION in session properties?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin
What is galaxy shema
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
What is the different lookup cache(s)?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
What are differences between Informatica 7.1 and 6.1
Teradata 
