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



Joined: 01 Oct 2008
Posts: 38

Points: 336

Post Posted: Thu Jan 08, 2009 3:39 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: TX
OS: Windows
Hello All,

I want to perform sequence generator transformatin in Datastage TX8.0 ,i have one diamension table in database and i want to generate
the surrogate key into the another fact table corresponding to primary key
of diamension table.

Any help is appreciable
Thanks in Advance

_________________
IBM Websphere Datastage Certified Professional
ray.wurlod

Premium Poster
Participant

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

Joined: 23 Oct 2002
Posts: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Thu Jan 08, 2009 4:43 am Reply with quote    Back to top    

Welcome aboard. Are you sure you mean TX ?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
Vishal1982
Participant



Joined: 01 Oct 2008
Posts: 38

Points: 336

Post Posted: Thu Jan 08, 2009 6:15 am Reply with quote    Back to top    

ray.wurlod wrote:
Welcome aboard. Are you sure you mean TX ? ...




Yes,i like to have the help in TX 8.0

_________________
IBM Websphere Datastage Certified Professional
Rate this response:  
Not yet rated
HariniAruna
Participant



Joined: 31 Mar 2008
Posts: 12

Points: 77

Post Posted: Fri Jan 30, 2009 1:02 am Reply with quote    Back to top    

Hi can u explain with example
what i understanding is u want to generate sequence number to the DB table is it the one ur asking?
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: 54479
Location: Sydney, Australia
Points: 295436

Post Posted: Fri Jan 30, 2009 1:11 am Reply with quote    Back to top    

U is not asking the question. Vishal1982 is.

The second person personal pronoun in English is spelled "you", not "u", and it its possessive case is spelled "your", not "ur".

Please strive for a professional standard of written English on DSXchange. Not only does this help those whose first language is not English, it also manages not to offend those of us who are professional and continue to support this site. Would you document your paid work as if it were a mobile telephone?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
Rate this response:  
Not yet rated
roydanlobo
Participant



Joined: 01 Mar 2010
Posts: 21

Points: 182

Post Posted: Thu Sep 23, 2010 8:38 am Reply with quote    Back to top    

Well if your question is regarding TX , i have a solution to generate a sequence number from a DB and if you are speaking about PX , Ray is the right guy but not in these forum start a topic in IBM PX forum ,

VALID(DBLOOKUP( "select fn_seq('xxx') from dual" ,"-MDQ xxx -DBNAME xxx -TE get_Next_FIle_nbr.DBL"),FAIL("Failed to get sequence Number from the hub : " + LASTERRORMSG()))

this should work , if u have the Database setup and running.
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