Data Warehouse Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Teradata (490)
Business Objects (875)
Cognos (1143)
Informatica (2428)

SAS (1049)
Micro Strategy (282)
ETL (315)
OBIEE (92)

Data Warehouse Interview Questions

Questions Answers Views Company eMail

/*i have the following dataset.*/ data score; input marks ; datalines; 10 20 30 40 50 60 70 80 90 100 ; run; Now i should get the result as sum of 1 to 5 i.e(10+20+30+40+50)=150 and 2 to 6 i.e(20+30+40+50+60)=200 and 3 to 7 i.e(30+40+50+60+70)=250 and so on. how to get it. thanks in advance

Eval Source,

2 4359

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2505

Stage is which type of load is it a full load or incremental load Please let me know in detail with best example

Infosys,

3 7479

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 3801

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

HP,

2182

How to prepared lld.can any one tell me detailed explanetion.

Bank Of America,

1977

hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer

Polaris,

1 3551

how to load meta data

IBM,

2 4415

I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?

2 3608

Are you aware of any limitations in Cognos?

HCL,

1 3018

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

CTS,

2 9743

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

Wipro,

4 8293

i have multiple .csv files in a unix directory. every file is having variable names as header.even for empty file also. suppose take 3 files a.csv b.csv c.csv a.csv contains data as name;age,salary; raja;34;4000; ravi;33;5000; kumar;25;3000; b.csv contains data as name;age,salary; ajay;40;4500; and c.csv contains name;age,salary; (only headers) Now i want to import and append all these files in to a single dataset. i tried infile statement with *.csv to import all at a time. but i m not getting correct data. please help me . its urgent. thank you in advance

Tech Mahindra,

2 4894

In which case u go for libname and in which case u go for proc sql pass thru facilit diff?

1 3620

I have a dataset with variables empid and doj how to calculate retirement age?

1 3921

Un-Answered Questions { Data Warehouse }

What are the difference types of stages?

1216

what is data integration? : Sas-di

1120

1. Explain your project.

2048

Explain standard filters?

1008

What a datastage macro?

1061

What are differences between different gde versions(1.10,1.11,1.12,1.13and 1.15)?

1100

Explain what are the basic needs to join two sources in a source qualifier?

1142

How to run a query in teradata?

1075

What is partitioned primary index (ppi)?

1048

What are the operations that support avoiding duplicate record?

1443

What is meant by Teradata Gateway?

1058

If a Node is busy what are the steps you can take to avoid ?

2416

What are the tracing options available in microstrategy object manager?

982

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1979

What are the measure objects?

1203

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