DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
malapatisreenu
Participant



Joined: 11 Dec 2005
Posts: 2

Points: 18

Post Posted: Fri Jan 27, 2006 5:16 pm Reply with quote    Back to top    

DataStage® Release: 7x
Job Type: Parallel
OS: Windows
Additional info: Factless Facttable
Factless Facttable


Last edited by malapatisreenu on Fri Jan 27, 2006 8:40 pm; edited 2 times in total
kumar_s

Premium Poster


since February 2006

Group memberships:
Premium Members, Heartland Usergroup

Joined: 16 Jun 2005
Posts: 5240

Points: 26349

Post Posted: Fri Jan 27, 2006 7:00 pm Reply with quote    Back to top    

Hi,
Welcome Aboard Very Happy

This is a forum for DataStage. Still pls be specific in what you are trying to ask.

In General, Fact tables are assumed to have lot of factcs, which in turns aggregated figures, numbers, amounts, measures.
As the one Factless Fact which doesnt deal with numbers rather other informations.


Also make your title bit meanig full

-Kumar
Rate this response:  
Not yet rated
malapatisreenu
Participant



Joined: 11 Dec 2005
Posts: 2

Points: 18

Post Posted: Fri Jan 27, 2006 9:06 pm Reply with quote    Back to top    

Thank you
Rate this response:  
Not yet rated
vmcburney

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup

Joined: 23 Jan 2003
Posts: 3564
Location: Australia, Melbourne
Points: 27712

Post Posted: Sat Jan 28, 2006 1:53 am Reply with quote    Back to top    

It was a questionless question about a factless facttable. Well handled by Kumar.

_________________
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn: Vincent McBurney LinkedIn
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54070
Location: Sydney, Australia
Points: 293276

Post Posted: Sat Jan 28, 2006 3:00 pm Reply with quote    Back to top    

A search of the forum would have revealed that a factless fact table records events for which there are no required measures.

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours