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 |
Explain the different lookup methods used in informatica?
What is a transaction control transformation?
How to Create a folder using pmrep command?
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
Is it possible to define a single node as a Gateway node as well as worker node?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What are the components of Informatica? And what is the purpose of each?
What is a rank transform?
How do you join more than 3 flat files in informatica?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
Where do you create/define mapping parameter and mapping variable?
What is the difference b/w natural key and surrogate key