Results 1 to 2 of 2

Thread: Is it possible to insert a recode into fact table

  1. 06-12-2007 #1
    Geek_Guest
    Guest

    Is it possible to insert a recode into fact table

    Hi guys I have one double please give me reply

    Is it possible to insert a recode into fact table, it means that record doesnt have primary key in dimention table for example we take emp, dept table. We dont have this recode in dept table

    deptno -- 50
    dname -- ABC
    LOC -- XYZ

    but we want insert into emp table
    empno - 1234
    ename --- abc
    deptno -- 50,

    is it possible?

    Regards
    Harish

    Reply With Quote Reply With Quote
  2. 09-04-2007 #2
    N SRIRAM K
    N SRIRAM K is offline
    Contributing Member
    Join Date
    May 2007
    Answers
    45

    Re: Is it possible to insert a recode into fact table

    If you claim that EMP as FACT table and DEPT as dimension then Not possible because FACT must have the referential integrity rule with their dimensions.

    Thx....@sriram_kumar@oneindia.in

    Thx
    SRIRAM N
    Hope Everything Good
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

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.
GeekInterview
Interact