At work we use DataStage which uses dataset (.ds) files. I can view the contents of the file from without our UNIX environment by using: orchadmin dump -name <dataset name> This only dumps the contents of the file to the screen. What I would like to do is have that dump stored inside a text file which I could then open/read from withi...
I have data coming in from datastage that is being put in our SQL Server 2008 database in a table: stg_table_outside_data. The ourside source is putting the data into that table every morning. I want to move the data from stg_table_outside_data to table_outside_data where I keep multiple days worth of data. I created a stored procedu...
Is there any way to script Datastage from python or the shell or something else? Something as simple as dropping a project from a server and rebuilding it in a script. Is there an object model? Anything? ...
I'm basically writing a ksh script that wraps over the dsjobs command to give my command-line-wary colleagues a simple interface from where they can view job logs, start/stop a job etc in case the clients at the Windows end crash (they often do). I've pretty much finished the script except a snag: the stageinfo option in dsjob doesn't g...
i need to copy the tables and data (about 5 yrs data, 6200 tables) stored in sqlserver, i am using datastage and odbc connection to connect and datstage automatically creates the table with data, but its taking 2-3 hours per table as tables are very large(0.5 gig, 300+columns and about 400k rows). How can i achieve this the fastes as at...
I was looking a report on internet that data warehousing is much lucrative and highly paid IT career. I am talking about technologies like abinitio etl datastage teradata. I work in ASP.net and sql server 05. Is it a good thought to move from web programming to data warehousing technologies. Since I would have no experience with data war...
Hi, How to identify the jobs which are modified today in datastage 8.1. Thanks Raghu ...