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

Difference between output_index and output_indexes in reformat

1230

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

869

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

770

1 1502

Intern stastical programmer written test

682

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

725

Tell me about MD5 functions in informatica

877

Tell me about Propagate functions in informatica

878

How to update a particular record in target with out running whole workflow?

1535

How you prepared reports for OLAP?

1547

How you know when to use a static cache and dynamic cache in lookup transformation?

1795

how will i can implement Insert a new record (if not present in Input file),Update the record (if present in input) a csv file in Abinitio

2065

How to insert/update a csv file by comparing it with another csv file? for example, i have 2 input files : ColA ColB ColC 1 A AA 2 B AB 3 C CC and second one : ColA ColB ColC 2 B BB 4 D DC Job should compare these 2 files and update the records present in first input file. so the output file will look like this: ColA ColB ColC 1 A AA 2 B BB 3 C CC 4 D DC

1945

how to insert/update a csv file by comparing it with another csv file?

2504

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

2164

Un-Answered Questions { Data Warehouse }

How will change port of obiee answers?

796

how to implement scd2 in datastage 7.5 with lookup stage

5552

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1009

Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.

1748

Which function is used to count the number of intervals between two sas dates?

1068

what are the reporting tools and difference between them?

2006

tell me few points when u become TL

2455

What are cluster analysis in data warehousing?

1049

what is the role of cognos comsultant?what actually it means?pls reply

2255

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1109

Explain substr function?

1032

How many ways are there to create ports?

1236

Explain the tuning lookup transformation - informatica

953

What are the data marts?

916

Explain what are non-additive facts in detail?

962

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