1. Categories >> Software >> Data Warehouse
  2. Suggest New Category


Data Warehouse Interview Questions
Questions Answers Views Company eMail

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.

 1032

What are the differences between oltp and olap?

 542

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

 512

Differentiate between reusable transformation and mapplet.

 559

Why update strategy and union transformations are active?

 583

What is meant by target load plan?

 547

How to join three sources using joiner?

 560

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

 652

What are the differences between source qualifier and joiner transformation?

 589

How do you convert single row from source into three rows into target?

 594

What are the types of schemas we have in data warehouse.

 522

Why update strategy and union transformations are active? Explain with examples.

 697

How do you remove duplicate records in informatica?

 1 705

How do you load alternate records into different tables through mapping flow?

 1280

How do you load first and last records into target table?

 653

Un-Answered Questions { Data Warehouse }

Can anybody tell me what are the tuning problems?

1582

what are sas/access and sas/connect? : Sas programming

539

State the differences between sql override and lookup override?

611

What are the steps involved in etl process?

510

What do you know about sas data set?

584




how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

1720

Explain why are oltp database designs not generally a good idea for a data warehouse?

617

How does the bre work with the co>operating system?

596

What are the different options associated with dsjob command?

929

What is the use of virtual processor connectivity in teradata?

559

how can we analyze the locks ?

1693

What is data validation strategies for data mart v?

546

What are stage variables, derivations and constants?

656

How do you convert basic cube to transaction cube and transaction cube to basic cube?

1761

How can create users and permissions in cognos?

554

For More Un-Answered { Data Warehouse } Questions Click Here