Topic :: Informatica





Informatica Interview Questions
Questions Answers Views Company eMail

What can we do to improve the performance of informatica aggregator transformation?

620

What is xml source qualifier transformation in informatica?

714

What is parallel processing in informatica?

1031

Difference between informatica vs ab initio?

713

How to pivot data using informatica when you have variable amount of pivot rows?

521

How to pivot row data using informatica?

519

What is difference between informatica power mart and power center?

565

Explain informatica architecture?

564

Different circumstance which drives informatica server to expel records?

556

Make a note of the quantity vaults made in informatica?

560

How can we use external procedural logic in informatica?

528

What are the different types of transformation available in informatica.

639

Explain what are the different types of transformation available in informatica.

575

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

609

How to do unit testing in informatica? How to load data in informatica ?

653




Related Topics


Un-Answered Questions { Informatica }

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

1728


Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

1587


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?

3318


How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?

1835


how do u implement configuration management in Informatica?

4365






can be used COM component in Informatica ?

1615


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.

1631


how do u handle performance issues in Informatica . where can u monitor the performance ?

4268


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

1734


can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1527


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

1557


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.

1559


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

2428


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.

1637


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

1505