Ardent DataStage(HELP)
Posted in 2000
Topics: Data Types & Schema Design
Hi Informix experts! Sorry if I wrong with conference, but in connexion with acquisition Ardent by Informix, I think I can do it. I'd like to know something about mechanisms for key-fileds building (without using target RDBMS data types, as autoincrement,serial or something else) I'm just interesting of Ardent possibilities for doing this (Universe as intermediate stage can be used). for easy example: I have two dimension tables(from different sources) first - id name second id name ------------- ------------- 1 AAA 1 KKK 2 BBB 2 LLL 3 CCC 3 AAA 4 DDD I want to merge "name" from these tables into one common dimension with key field: ID name ------------- 1 AAA 2 BBB 3 CCC 4 DDD 5 KKK 6 LLL How can I generate ID of this result table using DataStage? Thanks for advance. Any advises would be greatly appreciated.