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

Informatica Interview Questions

Questions Answers Views Company eMail

why dimenstion tables are denormalized in nature ?

3 9722

What is the use of incremental aggregation?

2 10254

What is the procedure to load the fact table.Give in detail?

1 8941

what is a junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 63858

What is the difference between Normal load and Bulk load?

5 51210

Discuss the advantages & Disadvantages of star & snowflake schema?

5 47035

what is a time dimension? give an example?

IBM,

2 12747

What are the reusable transforamtions?

1 5097

What is aggregate cache in aggregator transforamtion?

5 10006

What are the basic needs to join two sources in a source qualifier?

3 7430

In which circumstances that informatica server creates Reject files?

2 10263

Can you copy the session to a different folder or repository?

2 11909

When the informatica server marks that a batch is failed?

1 6123

What is a command that used to run a batch?

2 7616

In a sequential batch can you run the session if previous session fails?

4 11086

Post New Informatica Questions

Un-Answered Questions { Informatica }

Plz can any one say me how to get the informatica certification materials and dumps

2103

can anyone suggest best free Talend data integration training online

1745

What is event and what are the tasks related to it?

1209

how many types of dimensions are available in informatica?

1185

What is a rank transform?

1148

How to Create a folder using pmrep command?

1224

What is parallel processing in informatica?

1797

What is the difference between writing a joiner query in ANSI style and THETA style?

2436

Explain what is informatica metadata and where is it stored?

1113

What are the conditions needed to improve the performance of informatica aggregator transformation?

1141

What is a stored procedure transformation?

1113

Explain the informatica workflow?

1127

Explain how to import oracle sequence into informatica?

1072

How does a rank transform differ from aggregator transform functions max and min?

1263

What is joiner transformation in informatica?

1103

For More Un-Answered { Informatica } Questions Click Here