how we load the data from source to staging area

Answer Posted / manik

By using one to one mapping we can load data into staging area like how we will load Flat file data into staging relational table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can anyone suggest best free Talend data integration training online

1348


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

901


What is the need for an etl tool?

738


Enlist the advantages of informatica.

728


What is the way to execute pl/sql script using informatica mapping?

1083






What is an Integration service in Informatica?

802


How to create or import flat file definition in to the warehouse designer?

720


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2408


Explain your project of banking domian.

1290


How to load a Dimension ? and how to load a fact table?

1044


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6320


Design a mapping to load the cumulative sum of salaries of employees into target table?

1027


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1979


What are the new features of Power Center 5.0?

1336


How to start a workflow using pmcmd command?

811