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

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

For More Un-Answered { Informatica } Questions Click Here