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

what is the complex transformation you used in informatica

TCS,

1721

permutations of mapplet

TCS,

1531

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

TCS,

1 5968

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

TCS,

1 5138

Can anyone briefly describe abt audit table loading?

TCS,

2 5057

can anyone explain me about retail domain project in informatica?

Zensar,

6019

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

Amdocs,

2 4807

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

Amdocs,

3 10279

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

Amdocs,

2 4739

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

TCS,

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.

Amdocs,

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 data.now 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?

CGI,

1 9206

what is surrogate id ?

IBM,

3 5861


Post New Informatica Questions






Un-Answered Questions { Informatica }

How do you remove duplicate records in informatica?

147


How is union transformation utilized?

162


What is the function of aggregator transformation?

197


What is Data Caches size?

220


Could you explain what is enterprise data warehouse?

186






How to delete duplicate row using informatica?

180


can u any challenge your project?

1144


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

1510


explain about unit testing? in real time?

1166


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

436


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

176


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

1208


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

207


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

2786


What is Index Caches size?

193