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

Where the data cube technology is used?

1 1011

What are data modeling and data mining?

1 1138

What is surrogate key? Explain with examples.

1 1244

What is junk dimension? What is the difference between junk dimension and degenerated dimension?

1 1121

What is a real-time data warehouse?

1 1046

Can any one explain about core dimension, balanced dimension, and dirty dimension?

1 1121

How do you define data block size?

1 1107

What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?

1 1129

What are the possible data marts in retail sales?

1 1070

What is informatica architecture?

1 1119

What is a real-time data warehouse? How is it different from near to real-time data warehouse?

1 1015

explain about balanced dimension,

1 1047

Briefly state different between data ware house & data mart?

1 1114

What is an error log table in informatica occurs and how to maintain it in mapping?

1 1013

Explain batch processing in ab initio?

1 1502


Un-Answered Questions { Data Warehouse }

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2759


What is dimensional table?

1145


explain in detail about type 3?

1078


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

1076


what are the names of the reports that you prepared?

1185


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1654


create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2797


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2480


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8274


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2122


HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

2099


Explain what is aggregate table and aggregate fact table ... Any examples of both?

1168


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4788


Name at least 5 different types of transformations used in mapping design and state the use of each.?

1202


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2415