DSXchange

Hi gpatton,

I have only one root node.

Hi, I assume the following would work. But I am not very much confident about it. Assume that your table names are M (main table), A (Asset ID), B (Transaction_Sub_type), C (Transaction Type) and D (Source). What you can do is join M & A first, then join B with result, then C and finally D. Hope...

Hi Vincent & Kumar, Thanks for your suggestions. Actually I already did what is told by Vincent. But the sequence that I have mentioned is for testing purpose only, actually I need to write all my final data to a table and I may have to read a million records. OK, this is my logic. First I am so...

Hi Eze_ke,

As pointed out by Kris, in this case you have to go for join only. Lookup will return only the first matching record. So, you can't get all the duplicate records with Lookup.

Hi, I have a data file with data like this 1,a 1-10,t 1-11,u 1-12,v 1-10-20,x 1-10-25,y 1-11-26,z I need to convert this data as 1,a,1-10,t,1-10-20,x 1,a,1-10,t,1-10-25,y 1,a,1-11,u,1-11-26,z 1,a,1-12,v,,, For this, I created a job like Sequential -> Sort -> Transformer -> Sequential. In the Transfo...

Hi,

You can refer the link http://ibm.ascential.com/products/connectivity.html regarding the connectivity. But note that most of those PACKs didn't come by default and you have to pay for that.

Hi Ray, Thanks for your prompt reply and wishes for reaching 10000 posts. Probably I haven't phrased my first question properly. I don't want to insert a NULL value to a date field always. What I want is I am reading a field as Varchar and inserting the value to a datetime field in SQL server. The j...

Hi, I have a simple job which loads data from sequential file to SQL Server. For this, I am using a sequential file stage and SQL Server stage respectively. The mapping is 1:1. I am reading all the fields as Varchar, but loading the data as per the requirement. The problem is when I am loading a NUL...

Hi Bala,

You first check the value of APT_ORCHHOME variable defined at the project level. Please make sure it points to the pxengine folder. If it is correct, what you can do is, copy that value and instead of using APT_ORCHHOME/bin in PATH, u try with the actual value and check it.

Hi,

I am assuming that those 20 records are being rejected due to NULL value in some columns and there is no NULL handling routines. If so, what you can do is, use the function NullToValue() to set some value.

Hi, In your environmental variables, you make sure that when you have defined the PATH variable, APT_ORCHHOME/bin is appearing before the ORACLE_HOME/bin folder. You can see this information in the help document. In fact, I also got this error when I wrongly mentioned the values at the job level. Af...

Hi Balaji,

Yes it worked. Actually yesterday we found out this and removed the 'unicode' value from the Extended column against all the fields and then the job ran successfully. You got it right.

Thanks.

Hi, I want to move some data from Oracle to SQL Server thru DataStage. So, I created a parallel job with Oracle Stage and SQL Server Stage. If I pull data directly from an Oracle table, then it is working absolutely fine. But if I use an user-defined query, then I am getting the error while running ...