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

Informatica Interview Questions

Questions Answers Views Company eMail

tell me 5 session failure in real time how can you solve that in your project?

CSC,

2305

what type of documents you receiving from client later wt can you do? what type of documents have to prepare?

CGI,

2 6398

explain about unit testing? in real time?

L&T,

2209

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

Polaris,

1 6142

wf dont have integration severances how you can run?

TCS,

1941

how can run the wf through pmcmd commend? write script?

Cap Gemini,

2 8516

how to return multiple columes through through un-connect lookup?

DELL,

1 6985

explain one complex mapping with logic? sales project?

Accenture, JPMorgan Chase,

6677

Performance tuning in UNIX for informatica mappings?

CGI, CTC,

2570

How to Migrate the UNIX SCRIPTS from SIT TO PROD?

1 3053

How to do the error handling of if ur source is flatfiles?

1969

In ur current projectu have done any performance tuning of mappings?

1 4636

In which scenario did you used pushdown optimization?

1 3319

In which scenario did u used Mapping variable?

Cognizant,

1 2709

In Which scenario did u used Incremental loading?

2 6193

Post New Informatica Questions

Un-Answered Questions { Informatica }

Enlist the differences between database and data warehouse.

1127

Why union transformation is an active transformation?

1049

What does role playing dimension mean?

1048

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2147

what is $$$$?

2163

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628

What is sorter transformation?

1051

Define pmcmd command?

1048

How can you generate reports in informatica?

1035

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1905

what is the size of u r source(like file or table)?

2273

In development project what is the process to follow for an etl developer from day1

1724

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1015

Explain the types of lookup transformation?

1046

How many dimensions are there in informatica?

1094

For More Un-Answered { Informatica } Questions Click Here