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

Informatica Interview Questions
Questions Answers Views Company eMail

what is the complex transformation you used in informatica



permutations of mapplet



what is the flat file partition and where have to specify it


1 5968

Can we call a stored procedure from a unix script which is run using command task


1 5138

Can anyone briefly describe abt audit table loading?


2 5057

can anyone explain me about retail domain project in informatica?



waht is dataware house

2 3082

My source is like bellow F.NAME M.NAME L.NAME A B C D E F G H I and out put should like S.NO F.NAME M.NAME L.NAME 1 A B C 2 D E F 3 G H I 4 UNNOWN UNNOWN UNNOWN How can we acheive? please explane me indetail


2 4807

I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.


3 10279

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile


2 4739

What is CHECK-IN CHECK-OUT. Please explane me?


3 6507

Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.


1 4852

if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not

Cap Gemini,

2 4694

Performance wise which is better joiner or look up ? Give me with example?


1 9206

what is surrogate id ?


3 5861

Post New Informatica Questions

Un-Answered Questions { Informatica }

How do you remove duplicate records in informatica?


How is union transformation utilized?


What is the function of aggregator transformation?


What is Data Caches size?


Could you explain what is enterprise data warehouse?


How to delete duplicate row using informatica?


can u any challenge your project?


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa


explain about unit testing? in real time?


How do you load only null records into target? Explain through mapping flow.


How do you change a non-reusable transformation to reusable transformation?


Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps


What are the settings that you use to configure the joiner transformation?


Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM


What is Index Caches size?