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

Informatica Interview Questions

Questions Answers Views Company eMail

wht is cdc?how to use it in creation of mappings?

HSBC,

6 22937

wht target override?wht advantages it has compare to target update?

Polaris,

2 13809

how to calculate the optimum cache size in aggregator transformation?

1 7855

I'd like the load to be triggered by client. By placement of a file or somehow. How is it done in Informatica? I'm using version 7.1.4 This is so urgent - I really appreciate your help :-)

Alcatel-Lucent, ECI Telecom,

3 9120

What is the difference between Bitmap and Btree index?

Mind Tree,

3 20019

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 9640

How to delete duplicate record in Informatica?

7 30411

What is the difference between view and materialised view?

6 14471

Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 6983

how many types transformations supported by sortedinput?

4 8408

what is lookupoverriding?

1 5887

what is the process of target load planing?

IBM,

2 6649

what is the process we used in joiner transformation,there is no matching column in sources?

2 6871

what is the diff b/w union and joiner and lookup?

4 14633

how can u load the data in time dimension?

3 12329

Post New Informatica Questions

Un-Answered Questions { Informatica }

can anyone explain me about retail domain project in informatica?

7950

What do you mean by enterprise data warehousing?

1067

How can we improve session performance in aggregator transformation?

1123

differences between service based and product based?

2020

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1173

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2325

Difference between Target-based loading and constraint-based loading?

1009

What are the uses of etl tools?

1130

What are the measure objects?

1211

What is parallel processing in informatica?

1718

what is Active lock explain

2807

What is persistent lookup cache?

1037

how we can load rejected record's at run time?(not through bad files)

2384

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

1046

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2257

For More Un-Answered { Informatica } Questions Click Here