Follow Our FB Page << >> 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


3 4760

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


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?


2 5911

 Informatica Checkpoints



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


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. Thanks in advance


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


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,


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


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?


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.


2 4292

Post New Informatica Questions

Un-Answered Questions { Informatica }

Define mapping and session?


Explain pushdown optimization $pushdownconfig parameter - informatica


What is main use of mapplet?


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


What is incremental aggregation?


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


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


How will the document be delivered to me?


What is a predefined event?


What is deployment group?


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


What is standalone command task?


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


What could be the possible resons of locks by user?


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