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

1250

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)

890

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

787

1 1528

Intern stastical programmer written test

703

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

748

Tell me about MD5 functions in informatica

894

Tell me about Propagate functions in informatica

895

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

1551

How you prepared reports for OLAP?

1566

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

1817

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

2087

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

1967

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

2531

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.

2186

Un-Answered Questions { Data Warehouse }

What are the modules in Power Mart?

921

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

1023

Which date function advances a date, time or datetime value by a given interval?

1107

How many ways are there to do 'remove duplicate records in informatica'?

973

Explain translate function?

1153

what is enterprise guide? What is the use of it? : Sas programming

979

What are snapshots? What are materialized views & where do we use them?

1005

How are numeric and character missing values represented internally?

1629

Mention what dedup-component and replicate component does?

1002

can metadata be manually edited? If yes, how?

994

What are the different options available for update strategy?

962

Why update strategy and union transformations are active? Explain with examples.

1199

How many steps etl contains?

900

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

985

I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.

2118

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