DSXchange

hi When i gone through the manual,i found below two steps to prepare the data for correct lineage.These two steps establish the relationship between the tables and Job.what steps we have to perform from administrative side to find the relationship between Target table in Datstage Job and Report[IBM ...

Could anybody explain what is meant by datastage topology with respect to datastage?I know the meaning of Topology

I hope below link will help you


http://publib.boulder.ibm.com/infocente ... layer.html

Use Advanced find Option

1)View-->Details.Mention Jobname in Name to find

ok it is clear.What are the Things that we need to do to get Database and table information in Metadaworkbench.I think we have to follow the steps in below link http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.mdwb.tutorial.doc%2Ftopics%2Ft_import_objects....

1)Get the the list of the Jobs using dsjob -ljobs <project>
2)Identify restartability of Job by using dsjob -jobinfo <project> <job> command[Job Restartable]
3)The step 2 should be repeated for all the Jobs in a project[Use Unix scripting or Loop activity in Datastage]

Thanks for the input.When i gone through the below link. http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=%2Fcom.ibm.swg.im.iis.mdwb.tutorial.doc%2Ftopics%2Ft_import_objects.html Just we are importing Datastage Jobs into EWS.dsx but we are not using anywhere EWS.dsx file in Met...

Could anybody please clarify this doubt?

In our account we have around 30 different databases(oracle,sql server,teradata and netezza).But with repect to Datastage and reporting we are using only 3 databases(1-oracle,1-teradata and 1-netezza). Doubts: 1)Is metadataworkbench will contain information about 0nly 3 databases or all 30 different...

Could anybody reply what is the reason for the problem and how to resolve it?

No need to change anything in execute command activity.Just change the trigger condition to check whether it is 0 or 1 instead of 0.

In execute command stage use below command
date +"%u" which will return the 0(Sunday) and in trigger check whether it is zero or not.If it is zero means trigger the Sequence

In our account we have 1000 OWB Jobs approximately, these Jobs to be migrated to NEW tool Datastage. 1)I do not know how to proceed could anybody please help me how to proceed for migration? 2)Do we have any tool like connector Migration to achieve my requirement? AS of now I am analyzing existing J...

vamsi.4a6 wrote:If i am using multiple tables Joined based upon Join Keys or sub queries in source oracle connector I am not sure which table to use under option-Table name for partitioned reads?

Could anybody please clarify this doubt?

@chandra

Thanks for the input.one small clarification,If i am using multiple tables Joined based upon Join Keys or sub queries in source oracle connector I am not sure which table to use under option-Table name for partitioned reads?