Informatica Interview Questions
Questions Answers Views Company eMail

What are the two modes of datamovement in informatica sever?

2 5938

What is confirmed dimension and fact?

7 17079

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

2 8015

What is facttable granularity?

2 7209

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 28486

What are the different types of schemas?

ITC Infotech,

11 83050

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

7 11616

What are the different threads in DTM process?

2 8869

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

3 11356

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

4 33966

what are presession,postsession success and postsession failure commands ?

1 6077

What are mapping parametres and variables in informatica?

TCS,

6 33206

What is source qualifier?

SDS,

6 29536

What is the Difference between DSS & OLTP?

5 11088

Explain grouped cross tab?

Accenture,

1 13240


Post New Informatica Questions

Un-Answered Questions { Informatica }

What are different types of transformations available in informatica?

575


Reusable transformation and shortcut differences

1365


what are the deliverables?in your project?

1644


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

593


lookup transformation with screenshots

3548






What is workflow manager?

565


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

687


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6452


What are the different transaction levels available in transaction control transformation?

669


Define update strategy?

627


Explain constraint based loading in informatica

648


Explain the difference between a data warehouse and a data mart?

592


What is union transformation?

562


What is the need for an etl tool?

628


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1673