DSXchange

"Search" will help you. :D

mrajesh99 wrote:hi,
i am developing a parallel job to use Runtime Collumn Propagation using Shema file. i am struck at specifying the Description for the Collumns in schema file. Could any one please help me out on this issue. Thanks in advance.

How can we assume your issue?Please point out the problem.

Please be clear in title.You cannot give a hypothesis that parallel job does not run.

If I say ,in general, about parallel processing in Datastage,it depends on the environment that you use like SMP,Cluster or MPP .One physical node can be divided across multiple logical nodes which you build accordingly in config file of DS.For the scenario asked above,it was already explained in Pa...

There is only ever one conductor node. Assuming that APT_CONDUCTOR_NODE environment variable is not set, then the conductor node is the first-named node that is in the default node pool - in this par ... So I can conclude there is only one conductor node. However,you can change through env variable...

How about splitting into two jobs and making it as a sequence as look up reads all the data into memory and then starts processing.I am not sure,but it is not recommended for huge amounts of data.

joesat wrote:another query.. is there any way to execute these SQL statements from a command prompt rather than logging into DS Administrator?

You have to run them from DS Admin.

Example Config file stated in IBM book. node "n1"{ fastname "s1" pool "" "n1" "s1" "app2" "sort" resource disk "/orch/n1/d1"{} resource disk "/orch/n1/d2" {"bigdata"} resource scratchdisk"/temp&q...

Why JOBA and Job2 are running at sametime when Job2 is conditional with JOBA?

Install DB2 client on Windows and catalog the database.

You can refer Datastage pdf documents.

Comparison will be done on equality basis,actually there should not be a problem as both stages will compare the records.Some more information is needed to justify.

No.of CPU's used can be known by the Infrastructure admin.Generally no.of cpu's ~ no.of nodes.To improve performance,depending on resources available you can increase the node size in config file at the job level.Before doing this,check dump score of the job if any unnecessary sortings are present a...

Thank you..In fact,my input file timestamp is 11-May-2008 22:21:00.So I have customized the timestamp format to %dd-%mmm-%yyyy and I got the timestamp output which is compatible to DB2.Previously Iam using varchar data type to load this format and hence I have a problem. Thanks for your suggestions ...

Hi,
My input file date format is of type eg:17-May-2008.The database I am using is DB2 and its date format is yyyy-mm-dd.Can I have a solution for loading this type of input file format in terms of DB2 date?


Thanks in Advance
Kiran.