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 7264

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

CSC,

2 7348

 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 8077

 Informatica Checkpoints

DELL,

3330

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

DELL,

1 6149

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

2047

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 14390

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 10508

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 6133

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 9809

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

ITC Infotech,

2221

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

IBM,

6 9753

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 10267

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

TCS,

1 5822

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 6443

Post New Informatica Questions

Un-Answered Questions { Informatica }

Define the various join types of joiner transformation?

988

What do think which one is the better joiner or look up?

1203

What is powercenter on grid?

1179

What are the uses of etl tools?

1128

How to join three sources using joiner? Explain though mapping flow.

1147

Design a mapping to load a target table with the following values from the above source?

1346

What is fact table? Explain the different kinds of facts.

1076

Explain the shared cache and re-cache?

1116

What are the different types of repositories created using informatica?

1138

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128

What is joiner change?

1146

what is the complex transformation you used in informatica

2587

Enlist the differences between database and data warehouse.

1120

What is decode in static cache?

1179

What is pmcmd command?

1120

For More Un-Answered { Informatica } Questions Click Here