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 5664

expain about the tune parameters?

TCS,

2415

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

2064

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 4234

what is universe

TCS,

4 6469

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 5688

What is difference between drill through and drill down?

3 6606

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,

2373

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 10801

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 7083

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 7451

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

Accenture,

1 6520

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 7660

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 8265

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

3 5914

Un-Answered Questions { Data Warehouse }

what is the role of skipcheck in tm1?

can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1380

What is the use of %include statement?

1063

How to generate the cubes in framework manager?

1042

What are normalization, first normal form, second normal form and third normal form?

1054

I'm busy writing a report that's using report bursting, to be able to do this I need to use a sequential section. Using a sequential section cause the grouping of the original report not to work. Please can someone give me advise on how to come past this problem, the report need to use grouping as it depend largely on totals ect, and I need to use a sequential section within the report to be able to use the report bursting facility.

2779

what are different storage options supported by oracle ?

2092

What are common programming errors committed in sas

1150

can you change the location of the obiee repository?

847

What are slice and dice?

928

What is the syntax for m_dump in abinitio?

1626

Lookup constraints

1258

how to perform back drill through in cognos 8 what is the use of it

2544

Two default user groups created in the repository are____and_____.

2048

Which command is used to perform sorting in sas program?

1048

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