Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / simon
Staging area is a place where you hold temporary tables on data warehouse server. Staging tables are connected to work area or fact tables. We basically need staging area to hold the data, and perform data cleansing and merging, before loading the data into warehouse.
you can refer dwhlaureate.blogspot.com
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are different types of transformations available in informatica?
Explain about cumulative Sum or moving sum?
r u done any partitions in ur project?
What is the difference between STOP and ABORT options in Workflow Monitor?
How can you validate all mappings in the repository simultaneously?
What the difference is between a database, a data warehouse and a data mart?
Partition, what happens if the specified key range is shorter and longer
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Can we get 1st record through Informatica(without sequence number).
What are session parameters ? How do you set them?
What is the function of look up transformation?
What is union transformation in informatica?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
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
How can you define user defied event?
