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 9605

What is the use of incremental aggregation?

2 10151

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

1 8860

what is a junk dimension ?

Atos Origin, Cognizant, HS, NIIT, TCS,

14 63379

What is the difference between Normal load and Bulk load?

5 51002

Discuss the advantages & Disadvantages of star & snowflake schema?

5 46817

what is a time dimension? give an example?

IBM,

2 12626

What are the reusable transforamtions?

1 5030

What is aggregate cache in aggregator transforamtion?

5 9849

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

3 7327

In which circumstances that informatica server creates Reject files?

2 10185

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

2 11805

When the informatica server marks that a batch is failed?

1 6023

What is a command that used to run a batch?

2 7523

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

4 10911

Post New Informatica Questions

Un-Answered Questions { Informatica }

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7258

What are batches?

1107

What is persistent lookup cache?

1037

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

1201

How to create a non-reusable instance of reusable transformations?

1135

Define filter transformation?

1103

How can we use mapping variables in informatica?

1067

What is main use of mapplet?

1135

How can one identify whether mapping is correct or not without connecting session?

1457

What is rank index in rank transformation?

1082

How many transformations can be used in mapplets.

1940

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1966

what are the Methods For Creating Reusable Transformations?

1183

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1924

To import the flat file definition into the designer where should the flat file be placed?

1061

For More Un-Answered { Informatica } Questions Click Here