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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
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

For More Un-Answered { Informatica } Questions Click Here