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

1299

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)

924

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

837

1 1584

Intern stastical programmer written test

760

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

781

Tell me about MD5 functions in informatica

930

Tell me about Propagate functions in informatica

927

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

1584

How you prepared reports for OLAP?

1600

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

1857

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

2141

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

2027

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

2570

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.

2217

Un-Answered Questions { Data Warehouse }

How to do unit testing in informatica? How to load data in informatica ?

1130

In Teradata, how do we Generate Sequence?

1051

What is is a data flow graph?

1130

Name and describe few sas character functions that are used for data cleaning in brief.

1126

how can you import .csv file in to sas? : Sas programming

1104

What are objects? Name different type of objects in microstrategy?

940

complex mapping ur project u r invlve can u explain and give real time example give me ?

2311

How to create prompts in report net?

990

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2180

What is virtual Data Warehousing?

986

Why do we need informatica?

1002

hi friends pls forward impropmtu interview question

2133

Explain do we need an etl tool? When do we go for the tools in the market?

1023

What is the difference between 'using group by in the sql of the report' and 'having a group section in the report'?

944

in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt

1913

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