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

1294

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)

920

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

835

1 1580

Intern stastical programmer written test

748

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

779

Tell me about MD5 functions in informatica

929

Tell me about Propagate functions in informatica

922

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

1576

How you prepared reports for OLAP?

1595

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

1853

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

2133

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

2020

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

2567

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.

2216

Un-Answered Questions { Data Warehouse }

Where is tm1 web logging information found?

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1079

wat are deployement groups in informatica, how it will be used for developers

1719

What do you understand by term role-playing dimension?

1048

During the running session, output files are created by informatica server. Enlist few of them.

982

What are the different functions performed in development phase?

1080

Define query studio?

1001

if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1618

Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

1038

Explain what are the tasks that loadmanger process will do?

927

How were the reports scheduled and how to resolve unexecuted documents?

2674

How to create or import flat file definition in to the warehouse designer?

1068

where is the cache (lookup, index) created and how can you see it.

2017

What happens when a node suffers a downfall?

1129

What is the command used to run a batch?

1062

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