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.
No Answer is Posted For this Question
Be the First to Post Answer
What are snapshots?
What is etl process. How many steps etl contains explain with example?
What is tracing level and what are the types?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
where we cannot use sorter Transformation. if we use then we will not get correct data?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?
what is Forward,Reverse and Re_engineering?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
what are the reports developed in sap bw project and what is the requirement for developing it?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
how many maximum session supports to multiload in teradata ??