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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

2,can we insert duplicate data with dynamic look up cache,if yes than why and if no why?

TCS,

2 7515

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

TCS,

7 8046

differences between service based and product based?

Satyam,

1561

What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

Patni,

2 6693

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

Satyam,

3 5968

What is the architecture of ur project? can u explain it? PLz

Patni,

1 2858

Can we insert ,update ,delete in target tables with one update strategy tran.?

Zensar,

2 10448

why we use materialized view over view?

Zensar,

1 4469

can session assigned multiple mappings or not?

Zensar,

2 7068

we have to use order by,where,having we to implement sql query

Satyam,

1 4461

what is the default character set in teradata,,?

IBM, TCS,

2 10168

What is SQL Assistence?please eample

IBM,

4 6586

Difference between Microstrategy and Hyperion if any one Knows kindly updated me my dear Friends

 1 3585

in aggregator transformation we want to get middle record how to implement, source containg empno,name sal,deptno,address

Cognizant,

1 2377

in performance wise union is past,union all is past

2 4231

Un-Answered Questions { Data Warehouse }

What are batches?

614

Mention what dedup-component and replicate component does?

614

Mention what information does a .dbc file extension provides to connect to the database?

689

what do you mean by data staging area? : Sas-di

595

what are the deliverables?in your project?

1648




Explain informatica architecture - version 8 / 9

660

What are the benefits of using AWS Redshift?

5

How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?

525

What is a mapping?

556

what are passthrough functions?

494

What is the difference between account and directory options ?

616

Quickly characterize reusable change?

683

Explain the difference between view and materialized view?

504

How to create list output for cross-tabulations in proc freq?

616

How can we update a record in the target table without using update strategy?

646

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