What is staging area?

Answer Posted / sai suresh

Staging area is a where data transformaions takes place. It
is temparly storage area . Transformations like "DATA
SCRUBBING, DATA CLEANSING,DATA AGGREGATION,DATA MERGING"
The above transformations are takes place in the staging
area, in staging area data transformed from one format to
required business format then it will load into the target.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

1952


Differences between version 7.x and 8.x.

1524


What are session parameters ? How do you set them?

1463


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

706


What does role playing dimension mean?

716






Whats there in global repository

1349


Differentiate between Load Manager and DTM?

1761


What does “tail –f” command do and what is its use as an Informatica admin.

728


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1708


Define pmcmd command?

714


What is meant by LDAP users?

776


What is incremental aggregation?

673


Enlist few areas or real-time situations where informatica is required.

692


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

698


What do you mean by worklet?

721