ecoverdale

 Profile Answers by ecoverdale Questions by ecoverdale

• Dec 4th, 2007

In SQL Server terms:Only one clustered index is permitted on a table.When a delete statement is performed it is a logged transaction which can be rolled back.? The delete does nothing to the identity...

Hakoonamatata

 Profile Answers by Hakoonamatata Questions by Hakoonamatata

• Jul 9th, 2007

By definition, a clustered index  physically arranges all data in a table in a sequential manner. Since you can not have more than one physical arrangements of data in a table, you can have just ...

Answer Question  Select Best Answer

joanitah

 Profile Answers by joanitah Questions by joanitah

• Mar 12th, 2011

This is a process and outcomes of modeling a logical database schemas created to support OLAP and data warehousing solutions.

Hakoonamatata

 Profile Answers by Hakoonamatata Questions by Hakoonamatata

• Jul 9th, 2007

Here's a different way to look at dimensional modelling:Consider data to be a flat table for now. It would have some columns that contain numbers that need to be used in calcualtions later (e.g. b...

Answer Question  Select Best Answer

What is the relationship between company database and its data warehaouse?

Rajarao marisa

• Jun 6th, 2012

Hi, The main diff between database and data warehouse------> DW 1)Its stores historical & Summarized d...

prasadkawade

 Profile Answers by prasadkawade Questions by prasadkawade

• Mar 20th, 2012

Company database contains all the current data. whereas the data warehouse of means data repository. Database stores all the data on which business runs but database repository contains the data that ...

Answer Question  Select Best Answer

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 13th, 2007

Hi I believe that Dependent Dataware house are build on ODS. And Independent Dataware houses are real-time dataware having no dependency on any ODS systems. Regards,Ravi Kumar Garreravi_kumar_garre@yahoo.co.in

ravi_kumar_garre

 Profile Answers by ravi_kumar_garre Questions by ravi_kumar_garre

• Nov 12th, 2007

There is a third type of Datamart called Hybrid. The Hybrid datamart having source data from Operational systems or external files and central Datawarehouse as well. I will definitely check for D...

Answer Question  Select Best Answer

tisha24

 Profile Answers by tisha24 Questions by tisha24

• Dec 18th, 2008

One more is there, known as "GALAXY SCHEMA"

uma

• May 17th, 2007

There are 3 types of schemasstar schemasnowflake schemaand galaxy schemabyuma

Answer Question  Select Best Answer

Liam Whales

• Mar 24th, 2014

Moving from one software or hardware platform to another. Rather than the usual functional changes the aim is to keep the system functionally the same but move to the new platform.

JavidJaffer

• Jan 14th, 2014

System Conversion: is a common layman word, which has meany meanings to it: It can be: 1. Either Hardware Upgrade (Machines, Servers, LAN, Router, Switches) due to their Expansions in terms of volume...

Answer Question  Select Best Answer

Dominique

 Profile Answers by Dominique Questions by Dominique

• Sep 10th, 2009

A DW is no longer relevant when it contains inconsistent data. The strength of a DW - and its robustness - also relies on the validation processes... The sooner you can detect and report any inconsist...

Nitin

• Mar 17th, 2007

One of the main purpose of Datawarehousing is to get Cleanse data.So skipping data validatons is not a good idea.It will be better to bring the data to a staging area and perform validations.Or while pushing data from the source we can perform data validations.

Answer Question  Select Best Answer

Guest

• Jan 16th, 2007

Data can be viewed on a cube in multidimesional manner where we can see aggregated and summarized facts of variables/attributes .Thes is where olap comes into play.

obbantiga

 Profile Answers by obbantiga Questions by obbantiga

• Jan 3rd, 2007

A multi-dimensional structure called the data cube. In short described as a data abstraction that allows one to view aggregated data from a number of perspectives. Conceptually, the cube con...

Answer Question  Select Best Answer

praveen.p

 Profile Answers by praveen.p Questions by praveen.p

• Mar 9th, 2008

Use a bridge table.. as simple as that.

gopal

• Jan 25th, 2007

HiUpto my knowlege designers implementing this M-M relation asFirst break the schema to 1-M and M-1 relationsLet me correct if any thing is wrong

Answer Question  Select Best Answer

PANGANAMALA SRINIVAS

• May 9th, 2012

Fan trap: one of the schema-tables in your physical realization via an rdbms has a 1:many relationship between two slave-tables but there is no path between the two slave tables! So we are clueless ab...

johnftamburo

 Profile Answers by johnftamburo Questions by johnftamburo

• Mar 19th, 2009

A fan trap is a many-to-many relationship between two fact tables, bridged by a dimension.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

joshmohit  

 Profile Answers by joshmohit Questions by joshmohit

• Member Since Oct-2010 | Nov 3rd, 2010

---

Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the database specific properties which might not be covered with the generic definition of aggregate tables.

Tom Haughey

 Profile Answers by Tom Haughey Questions by Tom Haughey

• Apr 30th, 2012

?An aggregate table is a table that contains data that is summarized somehow, for example, it contains a summary of Customer by Product by Week. A more granular level of detail would be the transactio...

joshmohit

 Profile Answers by joshmohit Questions by joshmohit

• Nov 3rd, 2010

Aggregate table is a generic term to represent the summaries built in a warehouse. MAterilaized view is the technical implementation of these aggregate tables. Though, Materialized views come with the...

Improve Answer

How can we do the ETL testing on Data WareHouse?

wyaddow

 Profile Answers by wyaddow Questions by wyaddow

• Jan 22nd, 2010

As far as my knowledge we do not have any ETL Testing Certifications.

anita_09

 Profile Answers by anita_09 Questions by anita_09

• Sep 10th, 2009

ETL testing validates that data is transformed correctly from OLTP to data warehouse. Validating the data transformed includes following main verification points: Ensures that all expected...

Answer Question  Select Best Answer

What are the types of dimensions? Can you explainthe each type in short?

priyank_divya

 Profile Answers by priyank_divya Questions by priyank_divya

• Aug 28th, 2013

Conformed Dimension: Used across lines of businesses to gather information from across LOBs. Eg. if we want to know the deptnames where the avg salary of employees is more than the overall avg. Junk D...

Joe

• Aug 21st, 2012

1. Conformed Dimensions
2. Junk Dimensions

Answer Question  Select Best Answer

What is the main difference between Primary Index and Primary key in teradata? and can we have this two on same column?

uday

• Oct 13th, 2014

Primary Index in Teradata is used for loading and extracting the data from Database. (TD will load data Through PI
) and other hand PK is cluster index uniqe identifier. Pk will not allow Null and duplicates but for PI ok

Agnes Melbin R

• Apr 11th, 2013

If i am not wrong , both the titles should be swapped from the above answer as follows , Primary Key --Always Unique --Does not allow NULL values --Optional for a table --Values cant be updated --Doe...

Answer Question  Select Best Answer

How to read nth Row from a File using Sequential File Stage in Datastage
Scenario is as follows:
I have only two stages in a job
SeqFileStage1------> SeqFileStage2
I have to read only 6th Row from File 1 and write it in File2.

Biswajit Rath

• Mar 11th, 2018

We can solve the question by using the head as well as the tail command. So let me explain the answer for finding the nth line by using both the head and tail command. head -nthline fileName | tail -...

Krishna

• Sep 19th, 2017

In sequential file, Use the filter command head -6|tail -1

Answer Question  Select Best Answer

Manju

• Apr 29th, 2007

Context is basically used when we will have conformed dimension in the loop........

mrudula

• Mar 28th, 2007

Context is nothing but specifying the name of the paththe place where u cannot resolve the loops with allias there comes concept of contextalias is nothing but the duplicate name of some other table

Answer Question  Select Best Answer

VVM.SP

 Profile Answers by VVM.SP Questions by VVM.SP

• Mar 13th, 2008

It is a column, which we when update the OLTP

Anitha

• Feb 23rd, 2007

The columns(granular) that change the values over a perriod of time.

Answer Question  Select Best Answer

Priyanka Sathe

• May 8th, 2018

Teradata is a RDBMS used specially to build data warehousing applications.
The biggest strength of TD is parellelism.
TD distributes its workload evenly across its system and process it in parallel which makes it much faster than other databases.

Martin Alvarez

 Profile Answers by Martin Alvarez Questions by Martin Alvarez

• Mar 19th, 2012

Teradata and Oracle produce relational database management systems. What the previous answers do not provide are important facts about both platforms. Teradata products are a "combo" of hardware + so...

Answer Question  Select Best Answer

dhiveya.m

 Profile Answers by dhiveya.m Questions by dhiveya.m

• Apr 22nd, 2009

Mapping parameter are the constant values (values never changes) and mapping variables are the values that ever changes.

fir_dan

 Profile Answers by fir_dan Questions by fir_dan

• Jul 18th, 2008

A mapping parameter is a static value that you define before running the session and it retains the same value till the end of the session. Define a parameter in paramaeter file (.par) and use it in m...

Answer Question  Select Best Answer

rmanikandan

 Profile Answers by rmanikandan Questions by rmanikandan

• Apr 30th, 2008

Data warehousing is used to perform Historical records & providing all information by client users. Yes we can persom all the transformatioin usring oracle

prudhvi.g

• Sep 3rd, 2007

Datawarehousing is nothing but analysing the data and providing solutions to the business people.Major usage of datawarehousing is that it can analyse the data and stored the data which is historical.

Answer Question  Select Best Answer