Search:

Type: Posts; User: pat.mclean; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.01 seconds.

  1. Answers
    10
    Views
    28,124

    Data Warehousing - Re: Business Objects Universe

    In a generalized way it should go like this:
    1. read your SRS.
    2.understand your reporting requirements.
    3.Be through with reporting DB, in respect of Joins between the tables, typical query...
  2. Data Warehousing - Re: I need to know how to create a cube in powerplay

    There is yet another way....
    you can save the excelsheet as CSV file.
    Cognos Transformer supports CSV files as source. you can directly read the data from CSV file & start building your dimensions...
  3. Data Warehousing - Re: Can anyone help me to apply Cascading (nested) prompt

    Hey Kumar!
    you haven't specified which tool you are using. BusinessObjects has different method of creating cascading prompts than Cognos.

    if you can tell us on which tool you are looking...
  4. Answers
    2
    Views
    1,582

    Data Warehousing - Re: Creating a detail object

    well, there is 1 strong reason for it. say, i've customer name & ph_no as dimensions, BOBJ will try to calculate for both these objects if included in single query.
    If you are aware about...
  5. Answers
    1
    Views
    1,526

    Data Warehousing - Re: cognos and oracle relationship

    bhakshi, this sounds an interview question, why not try putting it in "Interview Questions" --> "Data Warehousing" --> "Cognos" ?
    it would be better if we discuss some real time problems or cases...
  6. Answers
    1
    Views
    1,899

    Data Warehousing - Re: How can we avoid 'No data fetch"

    Just a curiosity, have you tried writing macro for this?
  7. Data Warehousing - Re: Developing BO universe structure having two fact tables

    Hey Vekat, can u be more elaborative? are there any dimansions being shared by both fact tables? is it creating loops?
    if you look forward for perfect (or close to perfect sollution) try to be...
  8. Poll: Data Warehousing - Re: BusinessObjects Gurus, Attention Please!!!

    Well friends,
    Thanks for your reply !
    I'm obliged to know that you all are also looking forward for a common place to share knowledge & help others.:)

    Lets discuss, how this board can be...
  9. Answers
    2
    Views
    4,453

    Data Warehousing - Re: Ab Initio Guidence Please!

    Hey Admin,
    Thanks for the information:) . You have saved my time, I would have spent it in search of these resources. It seems, now I will have to play around with the tool & learn.:rolleyes:
    ...
  10. Answers
    2
    Views
    4,453

    Data Warehousing - Ab Initio Guidence Please!

    Dear All,
    Hi !

    I've to work on "Ab Initio" ETL tool & I'm absolutely newbie in it. I searched on web for the resources such as documentation, help etc. but not succeeded.

    Can anybody please...
  11. Answers
    3
    Views
    5,579

    General Re: Concept of Denormalization

    Denormalization is a data model designing technique. It is used for Data Warehouse designing. your transactional systems ([OLTP] - Billing or online booking systems for example) are in generally 3NF...
  12. Answers
    7
    Views
    5,807

    Data Warehousing - Re: Websites or books for Data warehousing

    Well, Ryan, The basic intention to build the data warehouse is to have a single version of truth of the historical enterprise data. The data warehouse building strategy is generally driven by the...
  13. Answers
    7
    Views
    5,807

    Data Warehousing - Re: Websites or books for Data warehousing

    visit Kimball Group: Data Warehouse Training, Consulting, and Kimball University, it has truckload of information.
    DataWarehousing.com - documenting data replication and data transformation ...
  14. Answers
    2
    Views
    4,485

    Oracle Re: Data type in SQL

    No. you can't insert alphanumeric data in numeric column. there are some functions to convert the data type like to_number(), to_char(), to_date() in Oracle.
    if your data is between 0-9 that is...
  15. Answers
    2
    Views
    6,405

    Re: 101 Useful Run Commands

    hey shivanna,
    its cool..... personally I love using shortcuts like these.
    thanks for adding lots of them in my poor list
  16. Answers
    5
    Views
    5,611

    Oracle Re: Oracle and MS Access

    If considering platform independent DB, it would be good to get into Oracle else, You always have an option of SQL Server.
  17. Answers
    2
    Views
    2,887

    Oracle Re: Operators in SQL

    Yes, all of them work in ORACLE.
    why don't you try it on your own?

    Patrick.:cool:
  18. Oracle Re: Creating a table by copying another table's structure

    create table target tablename as (select * from source tablename);

    Patrick.:cool:
  19. Answers
    20
    Views
    38,177

    Oracle Re: Dual Table in Oracle

    Dual table is like your scratch-pad. you can try different queries & functions using Dual.
    For. E.g. if you want to find out max of any numbers that are not present in your schema & you want to do...
  20. Answers
    3
    Views
    2,982

    Oracle Re: Letters of Oracle

    The numbers denote versions of ORACLE.
    Well, for 'i' in 8i or 9i I dont know but
    'g' in 10g stands for "GRID" i.e. Grid computing across the network.
    You can create clusters in network to...
  21. Re: Private Forum for Contributors and Moderators

    Hi Admin,

    Is this the list of private forum members?
    I'm interested in the contributions & according to your prior post, I have sent my experience info.(1.6 yrs Oracle, BusinessObjects,...
  22. Answers
    3
    Views
    2,372

    Re: Knowledge base questions - Paid Job

    Hi Admin!

    I've 1.5 yrs experience in Oracle, DWH, BusinessObjects Enterprise Suite (Supervisor,Designer,BusinessObjects,WebI).

    I deal with development as well as training new recruits on...
  23. Answers
    183
    Views
    157,201

    Re: SQL Quiz Package (100 Questions) Free Download

    Hi Admin!

    This quiz package is really awesome.:) Thanks for making such a great tool available for the newbies !

    I wonder if we can have something like this(may be a guide for dummies/newbies...
  24. Poll: Data Warehousing - BusinessObjects Gurus, Attention Please!!!

    Dear All,

    Hi !

    It seems preety good to have forums on this tech site!! I'm impressed!

    well, I was thinking about starting a Business Objects Forum right here on this site!

    How is the...
Results 1 to 24 of 26
Page 1 of 2 1 2
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact