Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Informatica Interview Questions
Questions Answers Views Company eMail

what is distinct

4 4394

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

4 5092

without table how to come first record only in oracle?

1704

can you use flat file for lookup table?why?

HCL,

2 7114

can you use flat file for repository?why?

TCS,

2 5960

what is hash table in informatica?

Zensar,

1 5804

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 7638

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 5717

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

TCS,

2 7944

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

5 6062

How are parameters defined in informatica?

HP, TCS,

3 7765

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 12727

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

TCS,

1 5928

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

IBM,

3 7141

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

IBM,

4 8821


Post New Informatica Questions

Un-Answered Questions { Informatica }

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1437


What is a stored procedure transformation?

448


Did u used latest transformations of 8.6.0? for what?

1326


What is a shortcut and copy in Informatica and how two are different with each other?

447


How to load last n records of file into target table - informatica

444






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

401


update strategy transformation in informatica

497


Briefly define a session task?

439


Explain the features of connected and unconnected lookup.

381


What is main use of mapplet?

465


COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1378


Explain about cumulative Sum or moving sum?

473


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

5658


How to load a Dimension ? and how to load a fact table?

802


What are the differences between source qualifier and joiner transformation?

433