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

where actually the usage of push down optimization happens...

2 Answers  


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,


During the running session, output files are created by informatica server. Enlist few of them.

0 Answers  


What are the advantages of informatica?

0 Answers  


Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,


Mention a few design and development best practices for informatica?

0 Answers  


What is power play plug in?

2 Answers  


How to eliminate 1st and last rows from the source and load the inbetween rows.

5 Answers   Syntel,


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

0 Answers  


what is the predefined port in dynamic lookup

2 Answers  


when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,


How do you change a non-reusable transformation to reusable transformation?

0 Answers  


Categories