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
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What is target load order?
What are the limitations of joiner transformation?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Explain dynamic target flat file name generation in informatica
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What do you mean by channel change?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Which version configuration tool used in ur project?
Can we create multiple integration service on single repository?
What is a sequence generator transformation?
What is the commit type if you have a transaction control transformation in the mapping?
What are the informatica performance improvement tips
What do you understand by term role-playing dimension?