Answer Posted / lakshminarayana
intermediate area between source system and data warehouse.it is temporary schema/user.after completion of each session we have to delete the previous data from staging area(table) before going to load data into staging area.it is used mainly for the purpose of increase the performance of source system means we perform join condition it will take lot of time to execute because join perform on the total data of table.but staging area required particular condition data means it required small amount data not the total copy of source data.and it used for clean the data before loading.it is relational data base.no end user can't access the data and no transformation perform on the staging area.if the session will failure then we directly receive particular data from staging area.means we can decrease the burden on source by using staging area.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of informatica?
According to his methodology what all you need before you build a datawarehouse
How can a transformation be made reusable?
How does the aggregator transformation handle null values?
What is the command used to run a batch?
What are the different transaction levels available in transaction control transformation?
What are the tuning techniques you applied during your last project
What are the tasks that can be performed using sq?
What is the use of target designer?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is native users?
How to join three sources using joiner? Explain though mapping flow.
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What do you mean by filter transformation?
How do you set a varible in incremental aggregation
