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

Informatica Interview Questions

Questions Answers Views Company eMail

what is distinct

4 6327

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 7341

without table how to come first record only in oracle?

2306

can you use flat file for lookup table?why?

HCL,

2 8619

can you use flat file for repository?why?

TCS,

2 7385

what is hash table in informatica?

Zensar,

1 7232

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

TCS,

4 9768

Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 7775

When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?

TCS,

2 9515

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 8869

How are parameters defined in informatica?

HP, TCS,

3 10230

What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?

TCS,

2 14842

What is sql query override? When did u use sql query override?

TCS,

1 7129

Whether Aggrigator transformation ignore the null values or consider the null values ? Advance Thanks, Manojkumar

IBM,

3 9117

How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

IBM,

4 11281

Post New Informatica Questions

Un-Answered Questions { Informatica }

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1734

What are the informatica performance improvement tips

1152

Is stop and abort are same in informatica?

1050

What is lookup transformation?

1096

Performance tuning( what you did in performance tuning)

2059

What is workflow? What are the components of workflow manager?

1235

What is rank transform?

1061

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2799

What is the difference between stop and abort in informatica

1144

Why union transformation is an active transformation?

1104

IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1115

Can we create a Integration service without a Repository service and vice versa?

1260

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

1194

What is the meaning of decode in informatica?

1167

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1023

For More Un-Answered { Informatica } Questions Click Here