Topic :: Informatica





Informatica Interview Questions
Questions Answers Views Company eMail

What are mapping parametres and variables in informatica?

TCS,

6 33271

How many repositories can we create in Informatica?

 3 7535

How the informatica server sorts the string values in Rank transformation?

Informatica,

1 17766

What are the types of data that passes between informatica server and stored procedure?

Informatica,

1 6490

What are two types of processes that informatica runs the session?

 2 18259

Why we use partitioning the session in informatica?

 2 13011

How the informatica server increases the session performance through partitioning the source?

 1 8123

What aer the out put files that the informatica server creates during the session running?

 4 17987

In which circumstances that informatica server creates Reject files?

 2 7042

When the informatica server marks that a batch is failed?

 2 5509

What is Performance tuning in Informatica?

CTS, GE, TCS,

1 42666

How can u work with remote database in informatica?did you work directly by using remote connections?

 2 7787

What are the new features in Informatica 5.0?

 1 4114

can someone give me an idea about informatica certifications Thanks in advance

CTS, NIIT,

2 6694

Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.

27 41406



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