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

Explain meta data?

1 1126

Explain why are oltp database designs not generally a good idea for a data warehouse?

1 1099

Tell me what is full load & incremental or refresh load?

1 1012

Explain is olap databases are called decision support system true/false?

1 1082

How can we determine what records to extract?

1 1172

What is a staging area? Do we need it? What is the purpose of a staging area?

1 1072

Explain which are the olap tools available that are supported by oracle?

1 1077

Explain some of modeling tools available in the market?

1 1051

Explain what are non-additive facts?

1 1089

Explain what is the difference between power center & power mart?

1 1070

Explain if a flat file cotains 1000 records how can I get first and last records only?

1 978

Explain what is fact less fact table? Where you have used it in your project?

1 1010

What does level of granularity of a fact table signify?

1 1176

What are the different methods of loading dimension tables?

1 1069

Explain what are the modules in power mart?

1 1118


Un-Answered Questions { Data Warehouse }

draw informatica architecture 8.6 ?

3947


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

8286


What is a rollup component? Explain about it.

1243


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3660


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

2167


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

1212


How do you remove duplicate records in informatica? And how many ways are there to do it?

1233


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.

2813


What is node? How many nodes and amps used in your previous project?

1173


what are the dimensions that you have in your current project?list them?

2093


What is dimensional table? Explain the different dimensions.

1269


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


Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this pls pls pls muthireddi@gmail.com

2209


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

1176


Have you have ever worked in unix environment and why it is useful in datastage?

1215