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
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain incremental aggregation in informatica
What is an Integration service in Informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What are the modules in Power Center
How to use pmcmd utility command?
Enlist the tasks for which source qualifier transformation is used.
What is rank transform?
Explain pmcmd command usage in informatica
What is the scenario which compels informatica server to reject files?
How do you load first and last records into target table?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?