Question { Cap Gemini, 9974 }

what is fact and what types of fact tables is there

Answer

Fact:
Fact represents business measure.
Fact table:
A fact table is the primary table in a dimensional model where the numerical performance measurements of the are stored.

Question { Cap Gemini, 5883 }

what is the purpose of surrogate key and diff between primary
key&surrogate key

Answer

primary-key:-
It represents one or more fields or attributes that uniquely identified each record in a database table.

surrogate-key:-It is a single part,artificially established identifier an entity,surrogate key assignment is a special case of derived data-one where the primary is derived.A common way that surrogate key values is to assign integer values sequentially.

Question { Cap Gemini, 19638 }

i having source, router transformation, two targets in my
mapping... i given two conditions in router
1)sal >500
2)sal < 5000
---------------
my source is havig two sal records (1)1000 (2)2000
then which target will load first? will both targets are get
load or single target only get load...... why?

Answer

Given
sal>500
sal<5000
sal 1(1000)
sal 2(5000)
By using router transformation both targets are get loaded,because here two sal are greaterthan 500 and lessthan 5000.