Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of maping in Getting Started Wizard?
- 1 Answers
- 5749 Views
- I also Faced
- E-Mail Answers
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 |
SRC1 -> EXP -> AGGR -> TGT SRC2 -> EXP -> Above is a maaping with two pipeline connected to the taret TGT. Design wise is this design is correct or not ?
I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?
What are the diffrences between joiner transformation and source qualifier transformation?
what are surrogate keys?
From where you extract the data, how you did it into informatica? explain....
1 Answers Accenture, Unisoft Infotech,
What is decode in static cache?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is incremental aggregation?
Explain pmcmd command usage in informatica
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
What is the difference between warehouse key and surrogate key?
What is a transaction control transformation?
Teradata 
