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

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

0 Answers  


what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,


Can you access a repository created in previous version of Informatica?

1 Answers  


What is the query to find nth highest salary? What is the use of cursors?

8 Answers   Keane India Ltd,


Is stop and abort are same in informatica?

0 Answers  






How many number of sessions that u can create in a batch?

3 Answers  


can a port in expression transf be given the name DISTINCT

3 Answers  


In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

8 Answers   Cap Gemini,


What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


What is degenerated dimention table?

7 Answers   Patni,


What are conformed dimensions?

1 Answers  


complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,


Categories