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 6170

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

4 7178

without table how to come first record only in oracle?

2252

can you use flat file for lookup table?why?

HCL,

2 8513

can you use flat file for repository?why?

TCS,

2 7292

what is hash table in informatica?

Zensar,

1 7122

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 9618

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 7652

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

TCS,

2 9408

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

5 8671

How are parameters defined in informatica?

HP, TCS,

3 10094

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 14721

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

TCS,

1 7045

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

IBM,

3 8975

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

IBM,

4 11114

Post New Informatica Questions

Un-Answered Questions { Informatica }

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1664

Enlist the advantages of informatica.

1068

What is mapplet in informatica?

1057

What are ETL Tools?

1117

Explain pushdown optimization and types in informatica

1077

State the limitations where we cannot use joiner in the mapping pipeline?

1065

What is mapping debugger?

1012

What is parallel processing in informatica?

1712

What are the types of schemas we have in data warehouse.

961

What is workflow monitor?

1060

What is a node in Informatica?

1041

How many ways are there to create ports?

1330

Explain how to import oracle sequence into informatica?

1011

Explain the types of lookup transformation?

1045

What is union transformation?

965

For More Un-Answered { Informatica } Questions Click Here