What are the types of maping in Getting Started Wizard?
Answer / swetha
Simple Pass through maping :
Loads a static fact or dimension table by inserting all
rows. Use this mapping when you want to drop all existing
data from your table before loading new data.
Slowly Growing target :
Loads a slowly growing fact or dimension table by inserting
new rows. Use this mapping to load new data when
existing data does not require updates.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the target load order?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Describe expression transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
can we override a native sql query within informatica? Where do we do it?
What are the Differences between static cache and dynamic cache?
How You Pull the records on daily basis into your ETL Server.
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
Why update strategy and union transformations are active? Explain with examples.
Repository user profiles
What are the types of schemas we have in data warehouse and what are the difference between them?
How many number of sessions can one group in batches?