1 Source to Staging Area 2 Staging area to work space 3 Work Space to dat

Explain Process flow in data warehouse??

Question Posted / parvar

Answer Posted / parvar

1 Source to Staging Area
2 Staging area to work space
3 Work Space to data ware house

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to join 3 database like flat file, oracle, db2 in informatrica?

1240

What is the difference between olap and datawarehosue?

957

How to get the first 100 rows from the flat file into the target?

1210

Why should we use data ware housing and how can you extract data for analysis with example?

1000

Explain a mapping, session, worklet, workflow, mapplet?

1109

How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?

981

What is an er diagram?

1052

What is the limit to the number of sources and targets you can have in a mapping?

1108

Difference between PowerPlay transformer and power play reports?

2517

What function should we use to display the value entered or selected by a user in response to a prompt?

989

What is the difference between agglomerative and divisive hierarchical clustering?

1186

Database in use is oracle?

1054

Start a batches with in a batch?

976

What is is the guidelines to build universe with better performance? R performance tuning issues of universes?

898

What is data warehosuing hierarchy?

1173