What is staging area?

Answer Posted / anju

staging area is used to integrate data from various
heterogenous sources. the advantage is recoverability. ie
if load session fails we can get data from staging area.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1717


How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1425


What is complex mapping?

756


What does update strategy mean, and what are the different option of it?

697


I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1580






Explain sessions. Explain how batches are used to combine executions?

695


what is unit testing?tell me proceedure

1882


Explain the informatica workflow?

696


How would you copy the content of one repository to another repository?

652


How we can create indexes after completing the loan process?

838


What is xml source qualifier transformation in informatica?

825


What is an Integration service in Informatica?

804


What are the types of presistent cache in look up tr.

1673


What are the new features of informatica 9.x in developer level?

645


Whats there in global repository

1349