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


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 17149

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

TCS,

3 8666

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

 4 24967

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

 1 5977

Can any body give the PDL with example?

Cap Gemini,

1 30386

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

 1727

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

1646

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 3961

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

 1 3870

What is audit table?

 1 5263

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 4734

How we can create SAS USER DEFINED CODE?

 1605

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

L&T,

1 3664

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,

1955

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 8353

Un-Answered Questions { Data Warehouse }

what are input dataset and output dataset options? : Sas programming

553

1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance

3757

Define enterprise data warehousing?

627

Define metrics studio?

571

i was asked what are the caluclations done by you in your report? plz give reply

1700




What are the types of data warehouse applications and what is the difference between data mining and data warehousing?

546

What is union transformation?

565

Difference between multiload and tpump?

615

Hi, I'm planning to write COG-132 exam so looking out for dumps. If anybody is having then please e-mail me at afrinshaikh86@gmail.com. your help would be appreciated. -Regards Afrin

1683

What is the differentiate between data file and descriptor file?

853

What is a Transformer?

645

What is the general format of function in sas? : sas-grid-administration

559

Differentiate between source qualifier and filter transformation?

988

What is the purpose of having stored procedures in a data-based?

562

Why is it required to maintain a parent-child relationship among the various attributes? What are the various types of relationships depending on the number of participants?

586

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