Topic :: Informatica





Informatica Interview Questions
Questions Answers Views Company eMail

How to do unit testing in informatica?

 829

How to handle decimal places while importing a flatfile into informatica?

 809

Explain where to store informatica rejected data? How to extract the informatica rejected data?

 692

What is the procedure for creating independent data marts from informatica 7.1?

 667

can we override a native sql query within informatica? How do we do it?

 743

How to load the data from people soft hrm to people soft erm using informatica?

 647

What is the difference between informatica 7.0 and 8.0?

 649

Whats the difference between informatica powercenter server, repositoryserver and repository?

 794

can we override a native sql query within informatica? Where do we do it? How do we do it?

 708

where to store informatica rejected data? How to extract the informatica rejected data?

 686

Explain how many types of dimensions are available in informatica?

 680

How many dimensions are there in informatica?

 717

Explain what transformation and how many are there in informatica?

 584

What are the static cache and dynamic cache in informatica?

 843

How to delete duplicate row using informatica?

 695



Related Topics


Un-Answered Questions { Informatica }

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

1800

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

1671

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?

3398

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

1917

how do u implement configuration management in Informatica?

4449




can be used COM component in Informatica ?

1696

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.

1732

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

4352

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

1815

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

1617

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?

1630

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.

1643

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?

2516

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.

1708

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

1585