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
Do you find any difficulty while working with flat files as source and target?
Enlist some properties of sessions.
Which transformation is needed while using the Cobol sources as source definitions?
Please let me know how to make encryption and decryption with example?
How can you increase the performance in joiner transformation?
What is deployment group?
What are the designer tools for creating transformations?
How can we update a record in the target table without using update strategy?
What is sorter transformation?
What is the procedure for creating independent data marts from informatica 7.1?
What is an active transformation?
What is status code in informatica?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
design of staging area?
What is workflow? What are the components of workflow manager?