Interested to Buy Any Domain ? << Click Here >> for more details...
What is a look up function? What is default transformation
for the look up function?
- 2 Answers
- 17075 Views
- ASM, TCS, I also Faced
- E-Mail Answers
Answer Posted / guest
look up compares the source to target.it update and insert
the new rows to the target.
the default transformation for look up is source qualifier
| Is This Answer Correct ? | 13 Yes | 9 No |
Post New Answer View All Answers
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Differentiate between a database and data warehouse?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
Explain the tuning lookup transformation - informatica
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is rank transformation?
Why update strategy and union transformations are active? Explain with examples.
Explain Dataware house architecture .how data flow from intial to end?
What are batches?
As union transformation gives UNION ALL output, how you will get the UNION output?
Under which circumstances, informatica server creates reject files?
Enlist few areas or real-time situations where informatica is required.
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are data-driven sessions?
What is data movement mode in Informatica and difference between them?
