Interested to Buy Any Domain ? << Click Here >> for more details...
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
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the Rank index port in Rank transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
Why filter transformation is an active one?
Differentiate between Load Manager and DTM?
Write the unconnected lookup syntax?
What is the way to execute pl/sql script using informatica mapping?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
explain abt ur project architecture?
During the running session, output files are created by informatica server. Enlist few of them.
What is meant by active and passive transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How can we update a record in the target table without using update strategy?
What do you understand by term role-playing dimension?
Explain what transformation and how many are there in informatica?
