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

Hi dude, i/p eno ename date edate deptno 1 x 10thjuly 30july A 2 y 10th aug 30 aug B 1 x 1aug ------ A 3 z 1jan ------ c 2 y 1sep ------ B o/p is eno ename date edate deptno 1 x 1aug ------ A 2 y 1sep ------ B 3 z 1jan ------ c Here edate is System generates we don't know that value. Please design the job by using SCD stage and Sql query. If any body know this answer please tel me. Tanks.

Amdocs,

1 5768

expain about the tune parameters?

TCS,

1 2470

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

1 2129

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

Amdocs, TCS,

1 4328

what is universe

TCS,

4 6678

firstobs and obs are working only option wise,but we are using infile statement with firstobs and obs in a statement wise? so firstobs,obs working at options and statemnts or not?

1 5769

What is difference between drill through and drill down?

3 6768

what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

Blue Star,

1 2429

if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually

Accenture,

4 10959

IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?

Accenture,

3 7226

I HAVE DRAGGED OBJECTS IN QUERY PANEL.... IF I CHECK THE SQL QUERY IT WAS SHOWING 2 QUERIES IN WHAT SITUATION IT WILL HAPPEN?

Accenture,

2 7575

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

Accenture,

1 6623

I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com

TCS,

2 7792

6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

TCS,

3 8429

what is the difference between the join and look up explin me one exmple

3 6064

Un-Answered Questions { Data Warehouse }

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6056

What is the purpose of Dataware Control?

1110

Explain about a time when you discovered a more efficient way to do a work task?

1214

How to create the source and target database connections in server manager?

1139

What is a rollup component? Explain about it.

1232

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3648

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2540

What is dimensional table? Explain the different dimensions.

1262

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2305

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2081

Demonstrate experience in maintaining quality process standards?

2658

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

2814

I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2253

Hi friends, what are the new features in abinito3.0?

2854

draw informatica architecture 8.6 ?

3939

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