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 6980

What is confirmed dimension and fact?

7 19636

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

2 9329

What is facttable granularity?

2 8233

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 31142

What are the different types of schemas?

ITC Infotech,

11 87145

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

7 13964

What are the different threads in DTM process?

2 9875

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

3 12764

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

4 35468

what are presession,postsession success and postsession failure commands ?

1 6791

What are mapping parametres and variables in informatica?

TCS,

6 35626

What is source qualifier?

SDS,

6 31654

What is the Difference between DSS & OLTP?

5 12773

Explain grouped cross tab?

Accenture,

1 14385

Post New Informatica Questions

Un-Answered Questions { Informatica }

Different qualification between a related rotate toward the sky and isolates look upward?

984

Clarify the utilization of aggregator cache record?

990

What is rank transform?

991

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2121

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

1057

What is informatica worklet?

1059

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

1115

Explain scd type 3 through mapping.

989

Define the various join types of joiner transformation?

986

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4156

What is sq transformation?

1156

Explain pmcmd command usage in informatica

1125

What is main use of mapplet?

1127

What is target load order?

1237

What is flashback table ? Advance thanks

1928

For More Un-Answered { Informatica } Questions Click Here