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,

2799

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

TCS,

1 10671

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

TCS,

1 11990

What is CDC? How to implement CDC?

People Tech, TCS,

4 23533

Tell me about informatica architecture.

TCS,

2 9640

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

iGate,

6 12135

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

iGate,

7 12700

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

iGate,

5 11098

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 8541

what are the row and column separations in Flat Files

CTS,

3 8584

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

1901

sample mappings for scd1,scd2 and scd3

Cognizant,

2 20779

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 12246

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

IBM,

1 7294

how to create a sample mapping for dynamic lookup transformation

2 5191

Post New Informatica Questions

Un-Answered Questions { Informatica }

What are different types of transformations available in informatica?

992

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?

1906

What is a difference between complete, stop and abort?

1083

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2075

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1084

What is the advantage of informatica?

1069

generate date / time dimension in informatica

1125

What are the types of data warehouses?

1526

Explain what is informatica metadata and where is it stored?

1050

How to create the source and target database connections in server manager?

1090

Difference between Target-based loading and constraint-based loading?

1000

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

1043

What all join we can perform in LOOKUP transformation?

978

Explain joiner transformation in informatica

1124

How can we delete duplicate rows from flat files?

1223

For More Un-Answered { Informatica } Questions Click Here