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.

 1036

What are the differences between oltp and olap?

 544

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

 515

Differentiate between reusable transformation and mapplet.

 563

Why update strategy and union transformations are active?

 587

What is meant by target load plan?

 550

How to join three sources using joiner?

 562

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

 654

What are the differences between source qualifier and joiner transformation?

 589

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

 598

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

 525

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

 701

How do you remove duplicate records in informatica?

 1 709

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

 1282

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

 660

Un-Answered Questions { Data Warehouse }

what is the use of skid in reporting?

1949

What is the difference between class statement and by statement in proc means?

637

Define APT_CONFIG in Datastage?

660

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1599

Which is the t/r that builts only single cache memory?

704




Your application mode has crashed. A.) How would you run your i-server? B.) How would you get the instance back?

498

Difference between nodup and nodupkey options?

628

How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

781

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2252

in sap bi we have wad, then why we go for sap bo

2771

What is source qualifier transformation in informatica?

569

what are the features in cognos8ui

1552

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1073

Can you connect multiload from ab initio?

636

Is the value of staging variable stored temporarily or permanently?

567

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