Informatica Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Informatica Interview Questions

Questions Answers Views Company eMail

what is the complex transformation you used in informatica

TCS,

2587

permutations of mapplet

TCS,

2511

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

TCS,

1 7656

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

TCS,

1 7088

Can anyone briefly describe abt audit table loading?

TCS,

2 6957

can anyone explain me about retail domain project in informatica?

Zensar,

7947

waht is dataware house

2 4806

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 6782

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

Amdocs,

3 13677

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

Amdocs,

2 6827

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

TCS,

3 8797

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 6847

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 6714

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

CGI,

1 11285

what is surrogate id ?

IBM,

3 8421

Post New Informatica Questions

Un-Answered Questions { Informatica }

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2003

If informatica has its scheduler why using third party scheduler?

1268

which one is better performance wise joiner or look up

1093

Define filter transformation?

1097

explan ur project architecture?

2069

What are mapplets?

1271

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

9821

How to go to the older version for a mapping?

1099

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

Could you explain what is enterprise data warehouse?

1148

Target increases every day even though no new record was inserted

1580

What are the components of Informatica? And what is the purpose of each?

1055

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675

What is informatica metadata and where is it stored?

991

Briefly define a session task?

1133

For More Un-Answered { Informatica } Questions Click Here