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

1350

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)

970

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

906

1 1659

Intern stastical programmer written test

792

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

827

Tell me about MD5 functions in informatica

983

Tell me about Propagate functions in informatica

980

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

1633

How you prepared reports for OLAP?

1661

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

1918

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

2184

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

2078

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

2627

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.

2266

Un-Answered Questions { Data Warehouse }

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

1014

Can we change Dynamic to Static or Persistent cache? If so what happens?

2261

is data integration and etl programming is same? : Sas-di

1125

What are ETL Tools?

1176

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1804

describe about physical data integration? : Sas-di

1096

hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

2045

how to change the execute of macro

2386

what do you mean by kimball?

1046

How to create context?

1065

How data is processed and what are the fundamentals of this approach?

1200

data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.

2256

Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2604

what is dynamic insert?

2256

What are the other names given to data warehousing?

1158

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