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


Please Help Members By Posting Answers For Below Questions

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2056


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

886


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1851


Explain incremental aggregation in informatica

858


What is an Integration service in Informatica?

893


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1543


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.

1360


What are the modules in Power Center

1420


How to use pmcmd utility command?

770


Enlist the tasks for which source qualifier transformation is used.

771


What is rank transform?

748


Explain pmcmd command usage in informatica

893


What is the scenario which compels informatica server to reject files?

812


How do you load first and last records into target table?

910


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?

764