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
which one is better performance wise joiner or look up
Where can we find the throughput option in informatica?
What are the reusable transformations?
Describe expression transformation?
How is union transformation utilized?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Do you find any difficulty while working with flat files as source and target?
How can one identify whether mapping is correct or not without connecting session?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to load a Dimension ? and how to load a fact table?
write a query to retrieve the latest records from the table sorted by version(scd)
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Enlist the tasks for which source qualifier transformation is used.
Explain what transformation and how many are there in informatica?
