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

Informatica Interview Questions

Questions Answers Views Company eMail

What are the two modes of datamovement in informatica sever?

2 6859

What is confirmed dimension and fact?

7 19342

What are reusable transformations in how many ways we can create them?

2 9207

What is facttable granularity?

2 8095

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

HeadStrong, TCS,

8 30858

What are the different types of schemas?

ITC Infotech,

11 86679

How to enter same record twice in the target table,explain?

7 13739

What are the different threads in DTM process?

2 9746

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 12615

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 35291

what are presession,postsession success and postsession failure commands ?

1 6722

What are mapping parametres and variables in informatica?

TCS,

6 35302

What is source qualifier?

SDS,

6 31482

What is the Difference between DSS & OLTP?

5 12569

Explain grouped cross tab?

Accenture,

1 14242

Post New Informatica Questions

Un-Answered Questions { Informatica }

State the limitations where we cannot use joiner in the mapping pipeline?

1000

What does reusable transformation mean?

1076

What is a transaction control transformation?

1146

Which is the t/r that builts only single cache memory?

1130

Can we create two repositories on same database instance in oracle?

1021

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

1147

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1029

What is native users?

1102

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1845

What can we do to improve the performance of informatica aggregator transformation?

1047

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1812

What is union transformation in informatica?

1102

How to improve the performance of a session using sorter transformation?

1096

How might one distinguish in the case of mapping is right or not without associating session?

1030

What is target load order?

1191

For More Un-Answered { Informatica } Questions Click Here