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

what is traffic lighting in business objects?

1 6777

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

ABC, TCS,

3800

i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest

3 9061

What is sdlc in bo?

2 4315

my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica

HCL,

1 4338

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

NTT Data,

3 7240

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

NTT Data,

2 7760

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

Cognizant, HCL,

1 9210

what is the difference between java script and html in cognos?

IBM,

1 5687

what is diff b/w datastage 8.1,8.5,8.7?

IBM,

1 9650

how does work server jobs?

1 4464

I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent

Polaris, Zensar,

5 10316

How we can see table structure?

iGate,

2 6757

What exact we can see in table?

1 3940

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2908

Un-Answered Questions { Data Warehouse }

name the data sources which are available with ti?

Within a cursor, how would you update fields on the row just fetched?

1075

Do you know the features of sas?

1047

Cleared COG-112 with 100% score today. What next certification should i go for?

1840

What is the benefit of partitioning a session?

1185

how tokens will generate?

2210

Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2749

List out some key concept of SAS

1136

What is process model?

1986

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1021

What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?

1269

explain the proc in sas? : Sas-administrator

1095

what is snowflake schema? : Sas-di

1216

Does redshift support unstructured data?

Can we create a Integration service without a Repository service and vice versa?

1218

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