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

Informatica Interview Questions

Questions Answers Views Company eMail

what is Active lock explain

Satyam,

2739

What are the different types of code pages available in informatica & how to implement it in your project?

TCS,

1 10588

What is the difference between unicode & ascii mode data movement in informatica?

TCS,

1 11904

What is CDC? How to implement CDC?

People Tech, TCS,

4 23319

Tell me about informatica architecture.

TCS,

2 9548

write a query for how to eliminate the duplicate rows without using distinct?

iGate,

6 11937

how to get the first row without using rank t/r?

iGate,

7 12498

what is the command to get the list of files in a directory in unix?

iGate,

5 10884

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 8455

what are the row and column separations in Flat Files

CTS,

3 8478

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1864

sample mappings for scd1,scd2 and scd3

Cognizant,

2 20678

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

Patni,

5 12049

what is procedure to use mapping variable in source qualifier transformation? with example

IBM,

1 7227

how to create a sample mapping for dynamic lookup transformation

2 5090

Post New Informatica Questions

Un-Answered Questions { Informatica }

In development project what is the process to follow for an etl developer from day1

1671

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1988

How an expression transformation differs from aggregator transformation?

1000

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2106

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2268

What is mapplet in informatica?

997

How to update a particular record in target with out running whole workflow?

1549

What is an Integration service in Informatica?

1094

How many ways are there to create ports?

1266

without table how to come first record only in oracle?

2216

Can you generate sequence numbers without using the sequence generator transformation?

1067

can anyone suggest best free Talend data integration training online

1641

expain about the tune parameters?

2356

Why update strategy and union transformations are active? Explain with examples.

1192

What is the surrogate key?

1175

For More Un-Answered { Informatica } Questions Click Here