1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category
Informatica Interview Questions
Questions Answers Views Company eMail

Write the unconnected lookup syntax?

 652

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

 590

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

 708

What is dimensional table? Explain the different dimensions.

 651

What are the types of caches in lookup?

 564

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

 547

Differentiate between router and filter transformation?

 608

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.

 1041

What are the differences between oltp and olap?

 546

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

 517

Differentiate between reusable transformation and mapplet.

 568

Why update strategy and union transformations are active?

 589

What is meant by target load plan?

 550

How to join three sources using joiner?

 567

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

 658

Post New Informatica Questions

Un-Answered Questions { Informatica }

Explain the different dimensions.

548

Can u generate reports in Informatica?

651

What is depict expression change?

614

What is session task and command task?

645

Explain informatica architecture - version 8 / 9

662




What do you mean by enterprise data warehousing?

638

What is the benefit of session partitioning?

589

which one is better performance wise joiner or look up

620

whats the logic to load the lower level of granularity of data to fact table.

1789

Explain incremental aggregation in informatica

650

What if the source is a flat-file?

586

What are ETL Tools?

662

Write the different tools in the workflow manager?

569

What do you understand by SOA of Informatica?

583

r u done any partitions in ur project?

1402

For More Un-Answered { Informatica } Questions Click Here