Why do we use DSS database for OLAP tools?
- 2 Answers
- 6267 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pushparao
DSS stands for decision support system.
it can used to implement effective decision making to
understood middle level management for OLAP systems.
that means reports are generated effectively in two and
multidimensional.
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pranu
DSS database is optimized for running data queries that do not change the data. Since OLAP tools are used for analyzing data by running analytical queries, it is best to use DSS database
| Is This Answer Correct ? | 0 Yes | 0 No |
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?
How can we create index after completion of load process?
what is the difference between stop and abort?
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
how to improve performence by using sorted input in aggrigator t/r.
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
how many data models u have done in informatica project?
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
A session S_MAP1 is in Repository A. While running the session error message has displayed
Teradata 
