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 3561

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

4 4285

without table how to come first record only in oracle?

1389

can you use flat file for lookup table?why?

HCL,

2 6343

can you use flat file for repository?why?

TCS,

2 5251

what is hash table in informatica?

Zensar,

1 5015

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 6503

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 4928

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

TCS,

2 7170

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

5 4829

How are parameters defined in informatica?

HP, TCS,

3 6841

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 11493

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

TCS,

1 5373

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

IBM,

3 6177

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

IBM,

4 7625


Post New Informatica Questions






Un-Answered Questions { Informatica }

Briefly explain the aggregator transformation?

151


What do think which one is the better joiner or look up?

173


4 yrs etl devloper roles and responsibilities?any body give solutions

1067


Briefly describe lookup transformation?

155


Slowly changing dimensions, types and where will you use them

790






What does “tail –f” command do and what is its use as an Informatica admin.

180


What is union transformation?

148


What is data caches/ index caches?

154


what is size of u r database?

1354


What are the different tools in workflow manager?

129


what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

977


When do you use sql override in a lookup transformation?

151


What is the use of code page?

156


Explain the difference between a data warehouse and a data mart?

146


what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not

1424