What are the types of maping in Getting Started Wizard?
Answer Posted / 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 |
Post New Answer View All Answers
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain the difference between a data warehouse and a data mart?
What is expression transformation?
can u any challenge your project?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Explian the Process of deployment groups in informatica
What is target load order?
How to load last n records of file into target table - informatica
Can we get 1st record through Informatica(without sequence number).
How can you validate all mappings in the repository simultaneously?
Describe expression transformation?
What is update strategy transform?
Describe data concatenation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
I have a flat file, want to reverse the contents of the flat file