how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

2050

Explain about hash partitioning?

539

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

1686

what is pmrep command?

1947

Explain about enterprise scalability and roi of data integration suite?

490

what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?

2162

can be used COM component in Informatica ?

1615

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?

1824

how do u really know that paging to disk is happening while u are using a lookup transform?

1562

What are the differences between sql override and update override?

573

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

785

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1394

explain the methodology of Data Warehousing?(Polaries)

1796

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.

1629

list and discuss two approaches for updation of target table in Informatica and how they are different.

1729