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

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

Axtria,

1 5610

Hi i want know mean and difference b/w render variable,conditional block and style variable please reply about them please be kind towards me

3 7727

why consolidation and custom group not used in ic cubes. and then i will over come by derived element.. what my question is ...even (consolidation and custom group) also derived element,why we are not used. Can any body give the assistant for this issues... Regards, sekhar

Cognizant,

1 10132

Which is Best Institute for learning SAS BASE & SAS BI in Hyderabad? Can anyone suggest me ?

ACC,

5 6487

What is informatica? What exactly are the practical uses in real world

2 6090

Difference Between Scan and Substr

2 17343

what is _error_?

Axis Bank, Cognizant, JPMorgan Chase,

2 10472

Hi friends, i have input like below naresh 10,20 suresh 30,40 i want out put like naresh 10 naresh 20 suresh 30 suresh 40 please help me thank you

3 11618

Hi friends i have 3 input files 1 is country file(cid,cname) 2 is State file(cid,sname) 3 is populate file(pid,sid,Adress) I want (cname & total poplation) how i can get the output please help me Thank you

1 9290

EmpId RollNo RollNo2 A t1 se A1 se tm i want output as A Emp A TL A1 SE etc how i can get output please send me your answer

Accenture,

3 8354

Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

2042

Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?

Cognizant, Cognos,

7 18063

HI EVERYONE I HAVE A QUESTION I FACED A QUESTITON FROM INTERVIEWER IN WEBI REPORT CREATING CROSS TAB REPORT FOR EX: YEAR IS COLUMN WISE AND MONTH IS ROW WISE AND INTERSECTIO IS REVENUES . HE WANTS BREAKS AT FIRST 3 MONTHS IN ROW LEVEL .. COULD U PLEASE TELL ME IF ANYONE KNOWS..

IBM,

4 11416

how to find unique records in informatica level

IBM,

1 3683

what is the difference between DUPKEY and NODUPKEY???

Cognizant, EXL,

4 23459


Un-Answered Questions { Data Warehouse }

Explain lookup transformation in informatica

1084


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1700


What is the difference between static cache and dynamic cache?

1004


What is the definition of cube in datawarehousing?

1006


Can we override a native sql query within informatica?

1049


What is conduct>it?

1124


How to generate sequence numbers without using the sequence generator transformation?

1220


Explain the difference between holap and rolap?

994


how to create reports on screech?

2570


what make u disappointmnets in u r career

2215


How sas treats the dsd delimiters?

1226


What is meta data and system catalog?

2311


what are the different types of fact structures?

1115


Input Data: AAABBBCC CCAAABB expected output A3B3C2 A3B2C2 How can I achieve this in Ab initio? where In output count of occurrences should be sorted from high to low

1485


How to calculate fact table granularity?

1031