How to compare Source and Target table, without using
dynamic lookup?
Answer Posted / davan
Am not sure ..default join of look is left out join
so...use of joiner t/r with left outer join..we have to
look up.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can u generate reports in Informatica?
What all are steps in up gradation of Informatica server?
What is the function of look up transformation?
Sequence generator, when you move from develoment to production how will you reset
Can we change Dynamic to Static or Persistent cache? If so what happens?
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 blocking transformation?
What is intricate mapping?
How do you load alternate records into different tables through mapping flow?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is rank transformation in informatica
What are the types of presistent cache in look up tr.
What are the data movement modes in informatica?
What is enterprise data warehousing?
Explain constraint based loading in informatica