DSXchange

out of 4 job i can see in one of them but rest 3 i cannot see the row count.

I cannot see the row count in the director client.

I am running a Datastage routine(DSLINKgetinfo) which calcultes row count on the link but that is not fetching any record count .it is displyaing Zero.

I have designed a job which is multiple instance and am calculating the number of rows flown in each of the links that are in the job. My problem is datastage is not showing the number of records that are flown into these link however that sequential file stage assocaited to this links are populated...

I have a job designed as below. Sequential File is making a look up on table and wrting to another file. The column which is used to make a look up is defined as decimal and in table it is varchar. so I converted varchar to decimal by using transformer stage and then made a look up. The issue is tab...

Hi, I have created a sequential file manually which has following data R00450000010100|ONE|ACTIVE|90286|DIRECT|2010-01-10|2011-01-10 R004P0000010100|ONE|ACTIVE|90286|DIRECT|2008-05-20|2011-01-10 R004000010100|ONE|ACTIVE|90286|DIRECT|2007-03-10|2011-01-10 When I read the above data in sequential file...

Hi, I have a requirement to pass value to variable $APT_CONFIG_FILE at run time. By Default in job i am using 8 node file to run the job. But while calling the job through unix script i want to change it to used 4 node. In Unix script i am not able to pass this value. I wanted to know how to assign ...

Data from source is as follows. a||metaway"insurance||b||c When i am creating a sequential file of above data in server by specifying option quite character values as " data loks like below. a||"metaway"insurance"||b||c Sequntial File Format in Server Edition: Delimiter=| Qu...

Record is been rejected and the error is

"no terminator found after TERMINATED and ENCLOSED field"

I have 2 sequential file which will load into a single table.One is created from server job and other is created from parallel job.Both will contain same type of data. I am having no issue loading to a table (via sql loader (oracle)) from the file which is created from server job but file which is c...

HI, First ption is ok. In second option in transformer how can i know is lookup passed or failed. In lookup datasets i have only Key column (sigle column). If lookup pass in any of the 3 lookup files , i have to write one column coming from source to another file which will be used in different job....

HI, First ption is ok. In second option in transformer how can i know is lookup passed or failed. In lookup datasets i have only Key column (sigle column). If lookup pass in any of the 3 lookup files , i have to write one column coming from source to another file which will be used in different job....

Hi, I am new to Datastage PX and wanted to know how to implement OR condition. I have 3 lookup's to make on 3 different files. If record is not not found in first lookup i should not drop or reject the record , i have to continue to search in other 2 lookup's. Can i implement with single lookup stag...

we are recieving sequnetial files from source system which are delimited by pipe. for one of the column called NAME is having characters with single quotes. like O'Brien. When inserting into oracle table through OCI stage load is aborted sue to single quotes in the name. Can you please help handling...

Could anyone help me what would be the impact if re-index is done by not loging as dsadm.

Thanks

many Thanks ray.i have found many of discusssion regarding migration of projects using Key word "Migration"