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 9427

What is the use of incremental aggregation?

2 10014

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

1 8761

what is a junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 62740

What is the difference between Normal load and Bulk load?

5 50655

Discuss the advantages & Disadvantages of star & snowflake schema?

5 46525

what is a time dimension? give an example?

IBM,

2 12467

What are the reusable transforamtions?

1 4913

What is aggregate cache in aggregator transforamtion?

5 9607

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

3 7169

In which circumstances that informatica server creates Reject files?

2 10040

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

2 11673

When the informatica server marks that a batch is failed?

1 5861

What is a command that used to run a batch?

2 7366

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

4 10676

Post New Informatica Questions

Un-Answered Questions { Informatica }

What is Index Caches size?

1055

How can we use mapping variables in informatica?

1002

What are the new features of informatica 9.x at the developer level?

986

Can we change Dynamic to Static or Persistent cache? If so what happens?

2147

How can you validate all mappings in the repository simultaneously?

1287

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2063

Which transformation is needed while using the Cobol sources as source definitions?

1124

Why do we need informatica?

926

What are active transformations.

1592

Which transformation should we use to normalise the COBOL and relational sources?

1141

Have you worked with/created Parameter file

1611

What is a shortcut and copy in Informatica and how two are different with each other?

1130

What is persistent lookup cache?

966

What are the new features of informatica 9.x in developer level?

937

What is meant by LDAP users?

1112

For More Un-Answered { Informatica } Questions Click Here