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...
Type: Posts; User: Shilpa.bateja; Keyword(s):
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...
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...
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...