Informatica Interview Questions
Questions Answers Views Company eMail

what is Active lock explain

Satyam,

2349

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

TCS,

1 9818

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

TCS,

1 11079

What is CDC? How to implement CDC?

People Tech, TCS,

4 21303

Tell me about informatica architecture.

TCS,

2 8727

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

iGate,

6 10229

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

iGate,

7 10442

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

iGate,

5 8662

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 7534

what are the row and column separations in Flat Files

CTS,

3 7344

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

1455

sample mappings for scd1,scd2 and scd3

Cognizant,

2 19627

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 10252

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

IBM,

1 6276

how to create a sample mapping for dynamic lookup transformation

2 4017


Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain why we use partitioning the session in informatica?

589


Differentiate between source qualifier and filter transformation?

968


Enlist the tasks for which source qualifier transformation is used.

564


How identifying bottlenecks in various components of informatica and resolving them?

560


What is complex mapping?

615






What are the new features of Power Center 5.0?

1208


How we can create indexes after completing the loan process?

698


What the difference is between a database, a data warehouse and a data mart?

571


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

571


What do you mean by enterprise data warehousing?

616


What is mapplet in informatica?

570


what are the different types of transformation available in informatica. And what are the mostly used ones among them?

520


What is confirmed fact in dataware housing?

5617


EXL informatica Questions

898


How to open an older version of an object in the workspace?

587