Interested to Buy Any Domain ? << Click Here >> for more details...
give detail on the sales project how many number of
dimensions & fact tables are used in projec briefly. how
the four fact tables taken in the project.
- 0 Answers
- 2371 Views
- HCL, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is Relational Integrity?
dimension object created in oracle can be imported in designer?how?
how would u estimate the size of Aggregator transform data and index cache?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
how do use session mapping parameters ?(in which transformation)
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
Can there be sub steps of etl steps?
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
How etl testing is different from database testing?
What is staging area referring to?
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
What are the various tools used in etl?
Teradata 
