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,

2532

permutations of mapplet

TCS,

2469

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

TCS,

1 7573

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

TCS,

1 6988

Can anyone briefly describe abt audit table loading?

TCS,

2 6856

can anyone explain me about retail domain project in informatica?

Zensar,

7901

waht is dataware house

2 4713

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 6667

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

Amdocs,

3 13540

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

Amdocs,

2 6698

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

TCS,

3 8662

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 6740

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 6621

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

CGI,

1 11193

what is surrogate id ?

IBM,

3 8255

Post New Informatica Questions

Un-Answered Questions { Informatica }

HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2064

What is an active transformation?

1047

What is a router transformation?

1063

Performance tuning( what you did in performance tuning)

1925

Enterprise data warehouse your projects phase by phase explain?

1869

What do you mean by filter transformation?

911

can anyone explain me about retail domain project in informatica?

7901

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1210

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2075

Write the prerequisite tasks to achieve the session partition?

1091

How can we handle two sessions in informatica?

995

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

961

What are pre and post-session shell commands?

1252

What are the new features of informatica 9.x in developer level?

949

What is a mapplet/worklet in informatica?

1137

For More Un-Answered { Informatica } Questions Click Here