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 6466

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 15787

whatis the default data driven operation in informatica

2 6890

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

CSC, TATA,

2 8460

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

Syntel,

5 26189

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 5258

What are the uses of a Parameter file?

CSC,

3 13645

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 6472

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 7216

List the transformation in informatica.

TCS,

1 12308

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

1 5063

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 6496

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 17771

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

Deloitte,

3 26289

What is the difference between IN and Exists in Oracle?

Deloitte,

4 18272

Post New Informatica Questions

Un-Answered Questions { Informatica }

EXL informatica Questions

1384

How many number of sessions can one group in batches?

1157

How can a transformation be made reusable?

1159

What is a pre-defined event and user-defined event?

1037

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

968

Suppose we do not group by on any ports of the aggregator what will be the output?

1041

How to implement security measures using repository manager?

1173

Define Pmrep command?

1050

Differences between connected and unconnected lookup?

1211

What is the difference between source qualifier transformations source filter to filter transformation?

1043

What does reusable transformation mean?

1130

What is a passive transformation?

1101

Explain joiner transformation in informatica

1124

What is depict expression change?

1114

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2143

For More Un-Answered { Informatica } Questions Click Here