Informatica Interview Questions
Questions Answers Views Company eMail

What are the two modes of datamovement in informatica sever?

2 5965

What is confirmed dimension and fact?

7 17134

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

2 8062

What is facttable granularity?

2 7225

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 28576

What are the different types of schemas?

ITC Infotech,

11 83179

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

7 11688

What are the different threads in DTM process?

2 8903

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

3 11391

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

4 34004

what are presession,postsession success and postsession failure commands ?

1 6093

What are mapping parametres and variables in informatica?

TCS,

6 33273

What is source qualifier?

SDS,

6 29595

What is the Difference between DSS & OLTP?

5 11136

Explain grouped cross tab?

Accenture,

1 13275


Post New Informatica Questions

Un-Answered Questions { Informatica }

Can u generate reports in Informatica?

658


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

713


COM components can be used in Informatica

1876


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

640


What are the issues you have faced in your project? How did you overcome those issues?

1915






what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1700


What does command task mean?

614


Define enterprise data warehousing?

636


what is index?how it can work in informatica

1588


On which transformations you created partitions in your project?

761


What does role playing dimension mean?

630


What are the types of presistent cache in look up tr.

1551


my source is junk data how will u remove that junk data by using unix please any one replay me

3243


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

685


what is SDLC way of code development?

1561