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

Write the unconnected lookup syntax?

246

Write the unconnected lookup syntax and how to return more than one column.

237

How do you remove duplicate records in informatica? And how many ways are there to do it?

272

What is dimensional table? Explain the different dimensions.

236

What are the types of caches in lookup?

236

What are the types of caches in lookup? Explain them.

219

Differentiate between router and filter transformation?

218

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

304

What are the differences between oltp and olap?

236

What are the types of schemas we have in data warehouse and what are the difference between them?

221

Differentiate between reusable transformation and mapplet.

209

Why update strategy and union transformations are active?

237

What is meant by target load plan?

236

How to join three sources using joiner?

229

How do you update the records with or without using update strategy?

251


Post New Informatica Questions






Un-Answered Questions { Informatica }

can u give example for factless fact table

4514


without table how to come first record only in oracle?

1481


How does the aggregator transformation handle null values?

242


What is domain in terms of informatica?

254


list out all the transformations which use cache?

285






What is meant by pre and post session shell command?

238


What is the use of target designer?

274


What is target designer and target load order?

272


How to join three sources using joiner? Explain though mapping flow.

248


What is rank transformation?

266


Explain the tuning lookup transformation - informatica

267


What is source qualifier transformation in informatica?

243


What are junk dimensions?

256


I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1224


Where do we use mapping variables in informatica?

254