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

Informatica Interview Questions

Questions Answers Views Company eMail

What is informatica etl tool?

1061

Differentiate between joiner and lookup transformation?

1161

What is workflow? What are the components of the workflow manager?

1175

What will be the approach?

1039

What is a snowflake schema?

1048

How will the document be delivered to me?

1131

What is a predefined event?

1137

Differentiate between mapping parameter and mapping variable?

1 1742

What is the sequence generator transformation in informatica?

1267

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1173

State the limitations where we cannot use joiner in the mapping pipeline?

1109

What if the source is a flat-file?

1171

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

1096

Write the different tools in the workflow manager?

1119

What is an expression transformation in informatica?

1094

Post New Informatica Questions

Un-Answered Questions { Informatica }

Tell me about MD5 functions in informatica

983

Please let me know how to make encryption and decryption with example?

1950

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1318

What does reusable transformation mean?

1199

Explain about Informatica server process that how it works relates to mapping variables?

1128

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

2439

write a query to retrieve the latest records from the table sorted by version(scd)

1125

What are the databases that informatica can connect to windows?

1103

Can we get 1st record through Informatica(without sequence number).

1522

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7189

explain abt ur project architecture?

2236

How do you promote a non-reusable transformation to reusable transformation?

1187

What is DR strategy for Informatica project?

1227

What is Data Caches size?

1130

What is the use of code page?

1178

For More Un-Answered { Informatica } Questions Click Here