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
- 12452 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
Is stop and abort are same in informatica?
How union transformation is used?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
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 does “tail –f” command do and what is its use as an Informatica admin.
Why do you use Mapping Parameter and mapping variable?
Define joiner transformation?
What are the differences between oltp and olap?
What are the limitations of joiner transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is the use of source qualifier?
Explain the informatica workflow?
where to store informatica rejected data? How to extract the informatica rejected data?
Tell me about Propagate functions in informatica
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
