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.

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?

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 ,

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