Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?

2 6478

If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?

6 15808

whatis the default data driven operation in informatica

2 6901

How to generate a single mapping for both the historical and incremental load.

CSC, TATA,

2 8480

How to eliminate 1st and last rows from the source and load the inbetween rows.

Syntel,

5 26212

How to calculate the cache size if say we are doing a performance check on a mapping and found that a particular cache needs to be changed. Is there a formula to calculate this! i know that informatica has a auto option available but how to calculate manually?

1 5266

What are the uses of a Parameter file?

CSC,

3 13665

By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?

1 6478

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 7222

List the transformation in informatica.

TCS,

1 12312

where does the default group roew in a router is stored what is the default size of memory in router

1 5070

If we use only lookup transformation in a mapping ie, SourceQualifier-->Lookup --> Target. , here datas are taking very long time to load in target., so what are steps to improve the performance in that mapping???????

2 6514

Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

Deloitte, TCS,

3 17788

can u apply SCD2 on flat file tgt? if yes wat is the procedure?

Deloitte,

3 26297

What is the difference between IN and Exists in Oracle?

Deloitte,

4 18294

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the new features of informatica 9.x in developer level?

998

What are the types of caches in lookup? Explain them.

970

How to create Target definition for flat files?

1225

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

Explain informatica architecture - version 8 / 9

1089

Which are the different editions of informatica powercenter that are available?

1034

What is fact table? Explain the different kinds of facts.

1076

Can we create multiple integration service on single repository?

1187

What are the conditions needed to improve the performance of informatica aggregator transformation?

1093

What is meant by pre and post session shell command?

1159

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1125

What is the maplet?

1119

What is the way to execute pl/sql script using informatica mapping?

1603

Write the program through which the records can be updated?

1005

Differentiate between a repository server and a powerhouse?

1118

For More Un-Answered { Informatica } Questions Click Here