how we load the data from source to staging area

Answers were Sorted based on User's Feedback



how we load the data from source to staging area..

Answer / jz

one to one mapping and through Bulk Loading

Is This Answer Correct ?    10 Yes 1 No

how we load the data from source to staging area..

Answer / cm

use sql loader

Is This Answer Correct ?    7 Yes 0 No

how we load the data from source to staging area..

Answer / 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

how we load the data from source to staging area..

Answer / moorthy g

Incremental Loading
(Change Data Capture)

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More Informatica Interview Questions

What are the data movement modes in informatcia?

1 Answers  


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  


i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....

1 Answers  


My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?

3 Answers  


2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

2 Answers   TCS,






in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,


Explain the types of lookup transformation?

0 Answers  


difference between repository database and repository service?

0 Answers  


how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,


what is the flow?

1 Answers  


who to split dimentions into sub dimention

3 Answers   Wipro,


what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,


Categories