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

Informatica Interview Questions

Questions Answers Views Company eMail

wht is cdc?how to use it in creation of mappings?

HSBC,

6 22893

wht target override?wht advantages it has compare to target update?

Polaris,

2 13803

how to calculate the optimum cache size in aggregator transformation?

1 7843

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

Alcatel-Lucent, ECI Telecom,

3 9097

What is the difference between Bitmap and Btree index?

Mind Tree,

3 19997

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 9617

How to delete duplicate record in Informatica?

7 30377

What is the difference between view and materialised view?

6 14439

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 6966

how many types transformations supported by sortedinput?

4 8380

what is lookupoverriding?

1 5872

what is the process of target load planing?

IBM,

2 6638

what is the process we used in joiner transformation,there is no matching column in sources?

2 6857

what is the diff b/w union and joiner and lookup?

4 14617

how can u load the data in time dimension?

3 12297

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is Index Caches size?

1110

What are mapplets? How is it different from a Reusable Transformation?

1085

Describe expression transformation?

1116

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

What are the reusable transformations?

1158

How to convert multiple rows to single row (multiple columns) in informatica

1376

What's the layout of parameter file (what does a parameter file contain?)?

2381

What is the meaning of up gradation of repository?

1980

How is union transformation utilized?

1005

How can we create index after completion of load process?

1117

explain about unit testing? in real time?

2196

What is a stored procedure transformation?

1049

What is meant by target load plan?

970

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

1043

For More Un-Answered { Informatica } Questions Click Here