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 6030

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

4 7019

without table how to come first record only in oracle?

2216

can you use flat file for lookup table?why?

HCL,

2 8410

can you use flat file for repository?why?

TCS,

2 7196

what is hash table in informatica?

Zensar,

1 7036

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 9477

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 7519

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

TCS,

2 9287

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

5 8478

How are parameters defined in informatica?

HP, TCS,

3 9973

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 14603

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

TCS,

1 6974

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

IBM,

3 8847

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

IBM,

4 10974

Post New Informatica Questions

Un-Answered Questions { Informatica }

How can we create index after completion of load process?

1084

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1047

Briefly describe lookup transformation?

994

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4692

How is union transformation utilized?

964

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1987

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1240

What is the advantage of informatica?

1025

Partition, what happens if the specified key range is shorter and longer

2450

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1740

What is target designer and target load order?

1057

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

1067

How many ways a relational source definition can be updated and what are they?

972

Define sessions in informatica etl?

984

Have you worked with/created Parameter file

1626

For More Un-Answered { Informatica } Questions Click Here