How do you load unique records into one target table and duplicate records into a different target table?
Explain the different kinds of facts.
How do you load only null records into target?
What is fact table? Explain the different kinds of facts.
How many ways are there to do 'remove duplicate records in informatica'?
How to join three sources using joiner? Explain though mapping flow.
How do you load only null records into target? Explain through mapping flow.
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??
Tell me about MD5 functions in informatica
Tell me about Propagate functions in informatica
How to update a particular record in target with out running whole workflow?
How you prepared reports for OLAP?
How you know when to use a static cache and dynamic cache in lookup transformation?