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


Data Warehouse Interview Questions
Questions Answers Views Company eMail

How many universes will run maximum in single project

HP,

1 3043

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

Infosys, Wells Fargo,

3899

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

Amex,

2 3412

What is the most complex report you have developed. Explain and how did you overcome??? Please give some examples

NTT Data,

2 3500

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

 2 13744

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

HCL,

1 2614

Source --------- eno , ename, sal 001,ank,1000 002,behe,2000 003,raj,2500 Target ------- header :DDMMYYYY24MMSS timestamp body: 001,ank,1000 002,behe,2000 003,raj,2500 footer: count(eno),sum(sal) how to implement the same in a FF tgt?

CTS,

2 3612

i have 50500 records in my source.if wf run for the first time it will load 1000 records into 1 tgt,if runs second time it will load to another tgt.targets are FF and it is need to be created dynamically.how many tgt will be created and how?

HCL,

1 3945

i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

HCL,

4 5497

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

TCS, Wipro,

4 6089

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

TCS, Wipro,

1578

How to move data set from one server to other?what are the steps to follow to do this?

 2 3549

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

 3 5092

why less number of records in loop? why more number of records in traps?

Wipro,

1 2739

Can we create datasets by proc step ? (Proc contents, Means)?

 2 3069

Un-Answered Questions { Data Warehouse }

Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.

1440

What do mean by local and global repository?

689

How do users receive only information that they want?

527

Difference between informat and format?

631

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4008




What is the difference between hashfile and sequential file?

704

I generated one report design time I can color green. At run I want bule how to change dynamically? And which method I can over write?

561

What are the applications primarily used by business analyst? : Sas-bi

543

how do u catch bad rows from OCI stage? And what CLI stands for?

2273

Hi Friends, Can anyone tell me. is there any certification in Database testing or BI testing or ETL testing international certification? Thanks ArunKumar

1550

Why and when do you use proc sql?

746

If a variable contains only numbers, can it be a character data type?

599

complex mapping ur project u r invlve can u explain and give real time example give me ?

1832

how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?

1826

How do you do backup and recovery in teradata?

536

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