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,

2534

permutations of mapplet

TCS,

2469

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

TCS,

1 7580

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

TCS,

1 6994

Can anyone briefly describe abt audit table loading?

TCS,

2 6860

can anyone explain me about retail domain project in informatica?

Zensar,

7902

waht is dataware house

2 4714

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 6674

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

Amdocs,

3 13547

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

Amdocs,

2 6704

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

TCS,

3 8664

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 6746

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 6625

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

CGI,

1 11197

what is surrogate id ?

IBM,

3 8269

Post New Informatica Questions

Un-Answered Questions { Informatica }

How many dimensions are there in informatica?

1045

How to Create a folder using pmrep command?

1124

waht type of interface is used for testing the data in informatica

2204

What is update strategy transform?

1040

How would you join a node to the already existing domain?

1082

Can we get 1st record through Informatica(without sequence number).

1431

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1599

Is it possible to revert a global repository to local one and why?

1039

How do you load first and last records into target table?

1116

How many number of sessions can one group in batches?

1114

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1069

How to generate sequence numbers without using the sequence generator transformation?

1148

Is it possible to use a client with different version than that of its Informatica server?

1094

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

1400

Design a mapping to load the cumulative sum of salaries of employees into target table?

1443

For More Un-Answered { Informatica } Questions Click Here