Search:

Type: Posts; User: Shilpa.bateja; Keyword(s):

Search: Search took 0.00 seconds.

  1. 09-25-2007

    Thread: Delete values in single a row without using DELETE keyword.

    by Shilpa.bateja
    Answers
    22
    Views
    14,181

    SQL Re: Delete values in single a row without using DELETE keyword.

    Nice question mikerich135
    According to me this technique will work well in case of data warehouse where u generally have no referencial integrity or soft referential integrity (where there is just a...
  2. 09-23-2007

    Thread: Examples for Star Schema & Snow flake schema

    by Shilpa.bateja
    Answers
    2
    Views
    12,423

    Data Warehousing - Re: Examples for Star Schema & Snow flake schema

    Star schema is one in which all the dimensions (lookup tables) are connected to fact table. [ highly denormalized]
    Snow flakes schema is one in which dimensions are normalized, but still fact are...
  3. 09-23-2007

    Thread: Delete values in single a row without using DELETE keyword.

    by Shilpa.bateja
    Answers
    22
    Views
    14,181

    SQL Re: Delete values in single a row without using DELETE keyword.

    Creating a table, and inserting everything except that row.
    Generally in data warehousing (some tools are not good with delete statement, like teradata). At that in case you have to delete or update...
Results 1 to 3 of 3
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