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,

2627

permutations of mapplet

TCS,

2551

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

TCS,

1 7751

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

TCS,

1 7195

Can anyone briefly describe abt audit table loading?

TCS,

2 7054

can anyone explain me about retail domain project in informatica?

Zensar,

8005

waht is dataware house

2 4901

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 6908

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

Amdocs,

3 13827

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

Amdocs,

2 6944

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

TCS,

3 8928

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 6969

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 6806

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

CGI,

1 11386

what is surrogate id ?

IBM,

3 8596

Post New Informatica Questions

Un-Answered Questions { Informatica }

How we can create indexes after completing the loan process?

1253

What is expression transformation?

1148

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1963

Describe data concatenation?

1127

What is data movement mode in Informatica and difference between them?

1187

how many types of dimensions are available in informatica?

1188

How can we use mapping variables in informatica? Where do we use them?

1295

Reusable transformation and shortcut differences

1884

What is incremental aggregation?

1138

Why do you use Mapping Parameter and mapping variable?

1811

What is a standalone command task?

1257

what is mean by complex business rule ?

2221

Is it possible to define a single node as a Gateway node as well as worker node?

1188

Explain the types of lookup transformation?

1109

What do you understand by SOA of Informatica?

1049

For More Un-Answered { Informatica } Questions Click Here