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 7277

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

CSC,

2 7359

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

 Informatica Checkpoints

DELL,

3334

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

DELL,

1 6158

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

2051

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 14407

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 10519

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 6140

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 9821

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

ITC Infotech,

2224

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

IBM,

6 9766

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 10277

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

TCS,

1 5827

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 6449

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are the various types of transformation?

1184

What is a repository? And how to add it in an informatica client?

1153

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1054

How you prepared reports for OLAP?

1600

What is depict expression change?

1127

What will be the approach?

991

The question was on time stamp. what is the difference between HH and HH24 when to use when.

2060

What do you mean incremental aggregation?

1085

Sequence generator, when you move from develoment to production how will you reset

2048

can we override a native sql query within informatica? Where do we do it?

1129

How to generate sequence numbers using expression transformation?

1095

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1067

Define filter transformation?

1103

What is joiner transformation?

1015

Write the program through which the records can be updated?

1010

For More Un-Answered { Informatica } Questions Click Here