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 6477

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 15806

whatis the default data driven operation in informatica

2 6899

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

CSC, TATA,

2 8477

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

Syntel,

5 26209

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 13663

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 6476

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 7221

List the transformation in informatica.

TCS,

1 12311

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

1 5069

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 6513

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 17786

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

Deloitte,

3 26296

What is the difference between IN and Exists in Oracle?

Deloitte,

4 18294

Post New Informatica Questions

Un-Answered Questions { Informatica }

Can we create a Integration service without a Repository service and vice versa?

1215

What is olap (on-line analytical processing?

1069

How to join three sources using joiner? Explain though mapping flow.

1147

Under what condition selecting sorted input in aggregator may fail the session?

1125

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1203

Enlist the advantages of informatica.

1068

Explain lookup transformation is active in informatica

1104

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2075

What is joiner change?

1146

waht type of interface is used for testing the data in informatica

2256

Write the advantages of partitioning a session?

1282

What are the settings that you use to configure the joiner transformation?

1055

Why do we need informatica?

990

Sequence generator, when you move from develoment to production how will you reset

2037

what is INFORMATICA TESTING process

2289

For More Un-Answered { Informatica } Questions Click Here