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
- 1624 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
How etl testing is different from database testing?
if i have a query as flat file how can we load data to target table
what are the reports developed in sap bw project and what is the requirement for developing it?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
what is dynamic insert?
Give the benefits of data integration suite?
Where can i get informatica certification Exam dumps and details? please forward it to emailid: krisboppana@yahoo.com
320 Answers Accenture, College School Exams Tests, CTS, Flextronics, HCL, Infosys, NexGen, Patni, SO, Wipro,
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What are the ETL Testing Operations?
When do we go for the tools in the market?
What is a lookup table in etl?
Can u access a repository created in previous version of Informatica?
Teradata 
