IN SCD TYPE 1 WHAT IS THE ALTERNATIVE TO THAT LOOKUP
TRANSFORMATION ?
Answer Posted / shashiall
plz..use "update else insert" in the properties of session.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Write the prerequisite tasks to achieve the session partition?
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?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
EXL informatica Questions
How identifying bottlenecks in various components of informatica and resolving them?
update strategy transformation in informatica
What is the commit type if you have a transaction control transformation in the mapping?
What is the use of an aggregator cache file?
What is native users?
Briefly describe lookup transformation?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is a rank transform?
What is a mapplet/worklet in informatica?
Target increases every day even though no new record was inserted