Page 1 of 1
Data Satge Architecture
Posted: Fri Aug 24, 2007 5:54 am
by SAMEENA
Hi all,
I have been using data stage tool for quite some time now.But am still not clear about its architecture.It would be great if any one suggest some books or links which might be useful.
thanks in advance.
Posted: Fri Aug 24, 2007 6:31 am
by chulett
Curiously, there is a FAQ on this subject:
viewtopic.php?t=90697
Posted: Mon Aug 27, 2007 12:54 am
by SAMEENA
Hi Chulett,
Thanks for the informative link.
I have a query after going through this FAQ:
If eah project is a schema residing on Universe Database then how come DSParams is a file which can be read , copied etc.
Besides is there any way to query this repository for our needs as in if I want to query table related to job log , is that possible?
Posted: Mon Aug 27, 2007 1:09 am
by ray.wurlod
1. Why not? A project is simultaneously a schema, a directory and an account.
2. Yes you can. The DataStage command for listing column definitions is LIST.DICT, for example LIST.DICT RT_LOG
But not all of the column definitions for this database are published. This is a deliberate decision by the vendor. You can also use dsjob command line interface which has four options for working with job logs.
Posted: Mon Aug 27, 2007 7:52 am
by SAMEENA
Hi Ray,
Please let me know if there is any reading material available on such commands.
Thanks in advance.
Posted: Mon Aug 27, 2007 8:10 am
by SAMEENA
Hi Ray,
Please let me know if there is any reading material available on such commands.
Thanks in advance.
Posted: Mon Aug 27, 2007 4:02 pm
by ArndW
The DataStage engine is a copy of UniVerse that was cloned several years ago. The two versions have drifted apart as many elements of UniVerse that are not required for DataStage have been removed and other aspects modified. But the base products are still very similar. IBM has bought the product and they have placed the complete suite of documentation on the following pages:
IBM UniVerse Documentation