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

1296

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

749

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?

1597

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

1855

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?

2568

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 }

State the difference between INFORMAT and FORMAT ?

1106

What is the ab initio business rules environment (bre)?

1172

What is aggregate table and aggregate fact table ... Any examples of both?

1063

What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

2040

What are the functions of the replicate and dedup component?

1092

Which development components of informatica have the highest usage?

1043

what is the procedure for scheduling conditional rendering?

2529

Explain what are the measure objects?

988

What is Indexing? how did u implement indexing?

2474

How to create context?

1011

What is a staging area? What is the purpose of a staging area?

885

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1259

Can we collect statistics on multiple columns?

1067

What is source qualifier transformation in informatica?

1011

I know of using applysimple, but there are other ways too?

960

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