can be used COM component in Informatica ?

2023

What is a mapping?

937

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?

3717

Explain etl mapping sheets?

1019

what is the difference steps for data modeling?

2049

What is a lookup table in etl?

1107

What do you understand by active and passive transformations?

882

What are the key benefits of ETL Testing?

986

List few etl bugs?

873

how does the server recongnise the source and target databases.Elaborate on this

2626

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.

2003

explain the methodology of Data Warehousing?(Polaries)

1936

how to load the data to fact table?

2638

Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.

1904

Identifying the bottlenecks in various components of Informatica and resolving them.

1872