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
- 11304 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
Sequence generator, when you move from develoment to production how will you reset
Can we override a native sql query within informatica?
Enlist few areas or real-time situations where informatica is required.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is meant by target load plan?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Differentiate between sessions and batches?
How to elaborate powercenter integration service?
Define mapping and session?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How might one distinguish in the case of mapping is right or not without associating session?
What is the difference between a connected look up and unconnected lookup?
Explain your project of banking domian.
How to load the data from people soft hrm to people soft erm using informatica?
What is a passive transformation?
