How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

780

What are the three tiers in etl?

582

What do you understand by the term ‘transformation’?

518

What are the modules in Power Mart?

524

Explain about round-robi?

617

How many types of transformations supported by sorted input?

685

Do we need an ETL tool? When do we go for the tools in the market?

518

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?

1841

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.

1624

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

1550

what is a worklet?

538

A session S_MAP1 is in Repository A. while running the session error message has displayed `server hot-ws270 is connect to Repository B`.what does it mean?

1817

What are dimensions?

573

what is the difference between cubes and package in cognos

4519

Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?

3306