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?

408

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

351

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

422

What is dimensional table? Explain the different dimensions.

349

What are the types of caches in lookup?

361

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

360

Differentiate between router and filter transformation?

367

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.

481

What are the differences between oltp and olap?

357

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

343

Differentiate between reusable transformation and mapplet.

330

Why update strategy and union transformations are active?

370

What is meant by target load plan?

357

How to join three sources using joiner?

347

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

392


Post New Informatica Questions

Un-Answered Questions { Informatica }

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5112


What is an expression transformation?

383


Explain the different kinds of facts.

357


What is an active transformation?

425


What is the different lookup cache(s)?

414






What is decode in static cache?

400


What is the difference between writing a joiner query in ANSI style and THETA style?

1684


Have you worked with/created Parameter file

1035


Plz can any one say me how to get the informatica certification materials and dumps

1382


What is persistent lookup cache?

379


Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6513


What happens when a session fails and you click on recover?

438


How identifying bottlenecks in various components of informatica and resolving them?

364


Write the different tools in the workflow manager?

345


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

381