Data Warehouse Interview Questions
Questions Answers Views Company eMail

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

TCS,

3 17129

Can we use Round Robin for aggregator?is there any benefit underlying?

TCS,

3 8649

How to add zero "0" before record in a field?

4 24952

Where in report Studio's property pane can I find NoDataHandler?

1 5966

Can any body give the PDL with example?

Cap Gemini,

1 30372

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

1721

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

1643

Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190

3 3950

when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.

1 3861

What is audit table?

1 5250

Hi, I have one dataset like id date ex: id date 1 13 1 13Oct2011 2 14 2 14Oct2011 3 15 3 15Oct2011 --->this is the current date here i want date format like 13Oct2011,14Oct2011 how we can modify the numeric to date format plz answer.

4 4719

How we can create SAS USER DEFINED CODE?

1600

i have a macro variable var1,var2. i want titles for the each macro variable separately? how it is possible?

L&T,

1 3656

i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

L&T,

1951

i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

L&T,

5 8345


Un-Answered Questions { Data Warehouse }

What is the difference between the content store and content manager?

556


i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

1658


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1606


What are the functions of the replicate and dedup component?

611


r u done any partitions in ur project?

1388






What is MAX CORE of a component?

694


Explain is there any other repository domains rather than universe, security, document?

567


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

533


what are the dimensions that you have in your current project?list them?

1626


what is the difference between floor and ceil functions in sas? : Sas-administrator

688


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1575


name the function which is used to serialize the ti process?

5


Explain what is the use of proc gplot?

690


What is a mapping?

548


I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series

1699