Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



Data Warehouse Interview Questions
Questions Answers Views Company eMail

we have a column of int/varchar datatype,but when we run the report we should get the date format i.e., suppose date key is a query item consists of data as 20040105,20030503,20060410....... output should be 5 jan 2004,3 may2003,10 apr 2006..........respectively.Can i knnow the answer

IBM,

4 7348

After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?

IBM,

1 4784

After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate

IBM,

1 2110

source target Q410 4 2010 Q311 3 2011 Q412 4 2012 Q309 3 2009

IBM,

1 4134

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

IBM,

3 7147

what is correlated query?

IBM,

2 6012

what is inline view?

IBM,

1 5419

How can I change reports to another package???

IBM,

3 7371

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

PayPal,

2 16168

what is data driven in update strategy transformation?

HCL, PayPal,

2 17484

what is system requirement(SR) & business requirement(BR)?

Ness Technologies,

2 6771

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 5942

Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best

L&T,

2 8062

checkout and checkin in informatica 8.6

TCS,

3 20223

How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)

TCS,

5 10319


Un-Answered Questions { Data Warehouse }

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1044


explain in detail about type 3?

1091


how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

2176


What are the data types present in bo? What happens if we implement view in the designer and report?

1082


how to generate the test data in sas without input data? : Sas-administrator

1207


Explain about a time when you discovered a more efficient way to do a work task?

1224


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

2067


Write the unconnected lookup syntax and how to return more than one column.

1175


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

2266


What r the names of the reports that you prepared?

1032


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2550


explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com

4194


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

2169


Hi friends, what are the new features in abinito3.0?

2860


Explain about a tricky situation for which you found a very simple solution?

1081