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

Informatica Interview Questions

Questions Answers Views Company eMail

what is Partitioning ? where we can use Partition?

IBM, TCS,

2 23497

what is surrogatekey ? In ur project in which situation u has used ? explain with example ?

6 14508

Where is the cache stored in informatica?

Infosys, Satyam,

5 38414

If you want to create indexes after the load process which transformation you choose?

HCL,

3 21688

what happens if you try to create a shortcut to a non- shared folder?

1 6830

what is polling?

Informatica,

1 7325

what is difference between dimention table and fact table?

1 8611

what is worklet and what use of worklet and in which situation we can use it?

Patni, TCS,

4 32326

How to import oracle sequence into Informatica?

Satyam,

3 17126

What is data merging,data cleansing,sampling?

4 10598

What is IQD file?

1 5696

How do you handle decimal places while importing a flatfile into informatica?

1 9391

what is the exact meaning of domain?

3 23755

what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?

1 4975

What is the difference between Power Centre and Power Mart?

TCS,

5 21751

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to extract sap data using informatica? What is abap? What are idocs?

1257

Is it possible to define a single node as a Gateway node as well as worker node?

1188

Define mapplet?

1060

What is domain in terms of informatica?

1062

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?

1023

Where are the source flat files kept before running the session?

1142

What is different between the data warehouse and data mart?

1114

What will be the approach?

1039

What are the different ways to implement parallel processing in informatica?

1490

Mention few advantages of router transformation over filter transformation.

1073

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

1052

Differentiate between reusable transformation and mapplet.

1146

What is dimensional table? Explain the different dimensions.

1256

how many types of dimensions are available in informatica?

1185

difference between repository database and repository service?

1225

For More Un-Answered { Informatica } Questions Click Here