1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

what is distinct

 4 4906

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

 4 5671

without table how to come first record only in oracle?

 1845

can you use flat file for lookup table?why?

HCL,

2 7579

can you use flat file for repository?why?

TCS,

2 6305

what is hash table in informatica?

Zensar,

1 6172

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 8242

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 6198

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

TCS,

2 8372

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

 5 6794

How are parameters defined in informatica?

HP, TCS,

3 8344

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 13401

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

TCS,

1 6290

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

IBM,

3 7663

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

IBM,

4 9421

Post New Informatica Questions

Un-Answered Questions { Informatica }

what is the size of your data warehousing?

1669

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1462

Mention a few design and development best practices for informatica?

555

How can you increase the performance in joiner transformation?

702

What are the various types of transformation?

638




What are the differences between source qualifier and joiner transformation?

591

Explain pmcmd command usage in informatica

699

Differentiate between Load Manager and DTM?

1659

Briefly describe lookup transformation?

596

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2133

Explain what are the different types of transformation available in informatica.

567

What is a grid in Informatica?

605

lookup transformation with screenshots

3555

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

621

How to call shell scripts from informatica?

570

For More Un-Answered { Informatica } Questions Click Here