What is staging area?

Answer Posted / tapsi

staging area is the place where data is collected from the
different sources and it was cleansed and made ready for
transformations.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you understand by term role-playing dimension?

566


Can we override a native sql query within informatica?

622


what is song in infrmatica...?

1666


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1073


Explain how many types of dimensions are available in informatica?

581






Explain the informatica workflow?

580


What is transformation?

651


What differs when we choose the sorted input for aggregator transformation?

565


Explain sessions and how many types of sessions are there?

576


Explain your project of banking domian.

1212


What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

4764


What is the need of an ETL tool?

634


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1692


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6745


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

716