Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

How to eliminate duplicates in FF and oracle both

CSC,

3 4760

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

CSC,

2 5473

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

 Informatica Checkpoints

DELL,

2469

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

DELL,

1 4645

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

1243

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 9448

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 7591

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 4018

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 7113

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

ITC Infotech,

1349

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

IBM,

6 6021

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 7775

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

TCS,

1 4451

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 4292


Post New Informatica Questions






Un-Answered Questions { Informatica }

Define mapping and session?

234


Explain pushdown optimization $pushdownconfig parameter - informatica

266


What is main use of mapplet?

229


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

7722


What is incremental aggregation?

211






Describe the impact of several join conditions and join order in a joiner transformation?

238


How can one identify whether mapping is correct or not without connecting session?

276


How will the document be delivered to me?

225


What is a predefined event?

240


What is deployment group?

257


Can we create two repositories on same database instance in oracle?

223


What is standalone command task?

267


In informatics server which files are created during the session rums?

240


What could be the possible resons of locks by user?

283


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1233