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
- 12335 Views
- Cognizant, HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How can we delete duplicate rows from flat files?
What do you understand by a term domain?
Which files are created during the session rums by informatics server?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How to join three sources using joiner?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Is it possible to use a client with different version than that of its Informatica server?
Differentiate between Load Manager and DTM?
Explain the difference between mapping parameter and mapping variable?
Why union transformation is an active transformation?
explan ur project architecture?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
what is song in infrmatica...?
What are the components of Informatica? And what is the purpose of each?
