Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 0 Answers
- 2061 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is Relational Integrity?
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?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
how would u estimate the size of Lookup transform data and index cache?
What exact we can see in table?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
What is tracing level?
where is the cache (lookup, index) created and how can you see it.
how do u really know that paging to disk is happening while u are using a lookup transform?
Two different admin users created for repository are________and_________.
Can anyone explain me a scenario from banking and finance...more precisely a mapping
When do we go for the tools in the market?
Teradata 
