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 9573

What is the use of incremental aggregation?

2 10135

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

1 8852

what is a junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 63263

What is the difference between Normal load and Bulk load?

5 50947

Discuss the advantages & Disadvantages of star & snowflake schema?

5 46774

what is a time dimension? give an example?

IBM,

2 12597

What are the reusable transforamtions?

1 5017

What is aggregate cache in aggregator transforamtion?

5 9817

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

3 7298

In which circumstances that informatica server creates Reject files?

2 10169

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

2 11791

When the informatica server marks that a batch is failed?

1 5976

What is a command that used to run a batch?

2 7503

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

4 10873

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the difference between STOP and ABORT options in Workflow Monitor?

1253

How do you load only null records into target?

1211

What are the settings that you use to configure the joiner transformation?

1049

How can we use batches?

1022

What is Session and Batches?

1102

Parameter and variable differences

2056

What is the use of transformation?

990

In which transformation you cannot drag ports into it?

1312

Name the different lookup cache(s)?

1226

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1122

what is SDLC way of code development?

2035

How to join three sources using joiner? Explain though mapping flow.

1141

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

1040

what is the complex transformation you used in informatica

2585

What is the reusable transformation?

1045

For More Un-Answered { Informatica } Questions Click Here