which table we load first in DW. dimension or fact? why?
- 4 Answers
- 6428 Views
- IBM, JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / mahesh225
Dimension tables will be loaded first.
www.futuresoftworld.com
www.futureitem.com
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Does anybody have the sample of delivery document of cognos, or provide some link of websites Thanks
What are the types of hierarchies?
Explain difference between powerplay transformer and power play reports?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
Explain the difference between powerplay transformer and power play reports?
Can you define cognos powerplay?
-------------How you design DWH?
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
Define dimensions?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
How can I test reports in cagonos?
what are the dimensions that you have in your current project?list them?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
