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 7524

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

TCS,

7 8063

differences between service based and product based?

Satyam,

1563

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

Patni,

2 6702

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 5969

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 10455

why we use materialized view over view?

Zensar,

1 4474

can session assigned multiple mappings or not?

Zensar,

2 7071

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

Satyam,

1 4464

what is the default character set in teradata,,?

IBM, TCS,

2 10172

What is SQL Assistence?please eample

IBM,

4 6599

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

 1 3589

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

Cognizant,

1 2379

in performance wise union is past,union all is past

2 4239

Un-Answered Questions { Data Warehouse }

What is the difference between writing a joiner query in ANSI style and THETA style?

1915

Do you need to know if there are any missing values?

591

how do the in= variables improve the capability of a merge? : Sas programming

931

how many numbers of cubes can we create on a single model? How can we navigate between those cubes?

588

what is catalog and types of catalogs in cagnos and which is better?

683




What is informatica etl tool?

548

What are the functions performed by bynet?

603

how you provide security to reports? How you provide security to packages ?

627

Fact table is in normalized or de-normalized form?

540

What is data mart in data warehouse?

528

What are the functions used for character handling?

635

What is a method to debug and test your SAS program?

710

How to start a workflow using pmcmd command?

707

Compare sas with other data analytics tools.

575

What are the default statistics that proc means produce?

597

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