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

Informatica Interview Questions

Questions Answers Views Company eMail

How to eliminate duplicates in FF and oracle both

CSC,

3 7129

If I am having 6 flat files in data. How can you load the data at a time

CSC,

2 7252

 Suppose you have n no.of records @ your flat file and you have seen some of records are missing while reaching to the destination. How can you trouble shoot it?

DELL,

2 7986

 Informatica Checkpoints

DELL,

3277

 Code page compatibly –Where all changes are made to handle the scenario.

DELL,

1 6067

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2006

In EMP table, for those emp whose Hiredate is same, update their sal by "sal+500" or else for others keep the sal as it is, how to do it by SQL query

Cap Gemini,

8 14159

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

Cap Gemini,

4 10378

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

IBM,

3 6007

I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

ITC Infotech, TCS,

3 9685

how do the project develops? pls specify right from the start to end in step by steps.

ITC Infotech,

2160

how may sources can be used in a mapping at a time?(limit)

IBM,

6 9557

what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).

IBM, ITC Infotech,

3 10142

What is the difference between a router and a filter transformation?

TCS,

1 5762

My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.

BirlaSoft,

2 6335

Post New Informatica Questions

Un-Answered Questions { Informatica }

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1082

What is the function of look up transformation?

1073

What are different types of transformations available in informatica?

955

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2118

Explain load alternative records / rows into multiple targets - informatica

1115

What is workflow? What are the components of the workflow manager?

1080

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1240

What is a joiner transformation and why it is an active one?

1023

What is sq transformation?

1097

Explain why we use partitioning the session in informatica?

1029

What is the different lookup cache(s)?

1048

What is event and what are the tasks related to it?

1074

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2014

Enterprise data warehouse your projects phase by phase explain?

1873

What is transformation?

1061

For More Un-Answered { Informatica } Questions Click Here