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

This question is asking in many interviews,,,,, What is your challenging task in report studio? anybody pls tell me some 2 or 3 challenging tasks,,,,

2308

What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,

2 12667

If you got any problems while developing the reports, then what will you do? How will you debug the problems? This question isasking in many interviews,,,, pls help me,,,

2143

These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?

IBM, Logica CMG,

6 10188

How to execute the MACRO through Infoview?

1 9332

how to calculate the optimum cache size in aggregator transformation?

1 7867

If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?

HCL,

8 14059

How did you use the round function?give an example(don't say it will round to the nearest intger) eg1:round(84.55,.1) =84.6 eg2:round(92.64,.1)=92.6,How it is happening like this tell me the logic,that is how the round function works when we have deimal values?

BoA,

2 29149

What are MIs reports? what is the use of MIS reports and How can u generate the MIS reports in SAS? If any body know explain with the eg.

ABC, ASD Lab, CitiGroup,

2 15244

Hi... this is chandu, did MSc Microbiology, trying to get job in SAS tool, PLZ Tell me whether IT industries will give consider my education to gain a job....?

2 6019

What is a macro routine?

2739

if x=round(26.3,10)-1 then x= how much and how explain?

BoA,

5 10620

what is document design in boxi,have u participate in that

Accenture, TCS,

2205

what r the disadvanges in boxir2

Accenture,

3 9173

what is isolated joins in check integrity

Accenture, Polaris,

2 18159


Un-Answered Questions { Data Warehouse }

what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.

2253


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2143


What are the processing stages?

1111


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

1174


If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1508


what is the use of backward drilling in cognos 8?is it possible?whats the uws of it?

2084


How can we load the time dimension?

1211


Explain when do we analyze the tables? How do we do it?

1010


Why null values are mapped as 0 in fact tables?

1017


How will you create interactive dashboards ?

919


How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1789


Is possible to create skid in dim,fact tables?

2656


Syntax for case when statement?

1077


how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2711


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1295