DSXchange

Hi, I have file in unix whcih has the following structure: TableName|Src|FileId|Processed|Inserts|Updates|Rejects|Datafiles Processed|TimeStamp | AMZN_SHIP_TRAK_W | 71| 8| 148221| 148221| 0| 0|10/18/07-10/18/07 | Fri Oct 19 07:44:50 2007 1 of 7 tables loaded Following tables NOT loaded: AMZN_PMTN_W ...

Hi, I have a file in Unix which is in this format. I want to use this as a source in my Datastage job. The problem is the file is located in Unix Env, where the path is differnet from our working directory path. there are 5 differnt files, with this structure. how can i use these in datastage and wh...

Hi, I am facing one problem that is in orcale database we are using CLOB datatype now when i import metadata into datastage it will take LongVarchar(4000) only. now i changed this length inot LongVarchr(20000) in datastage and i ran the job still it was support only 4000 remining characters are trim...

Not really, what was unclear? I note that you don't have premium membership so can't read the entire post. So even if I posted a more complete answer, you'd still only be able to see the first 200 or so characters of it. Read the help or the manuals about each of the stages I've referred to, and st...

ray.wurlod wrote:Sort data on the first two columns, have the Sort stage generate a Key Change column.
In a Transformer stage use stage variables to accumulate the third column, and use the Key Change column to trigg ...

Hi Ray,
Can u explain me little more detial.

Hi
How can we remove web characters from the incoming string.
any logic.
i do no thave any example for this.

thanks

Hi My source is oracle table and columns are: elmt_i,node_i,name 1,10,a 1,10,b 1,10,c 1,10,d 2,10,a 2,10,b 3,10,c 3,10,d Mytarget is oracle table and result should be: elmt_i,node_i,name 1,10,abcd 1,10,abcd 1,10,abcd 1,10,abcd 2,10,ab 2,10,ab 3,10,cd 3,10,cd i.e. based on elmt_i i have to concatenat...

Hi I am getting the following error while i m running the job. Could u plza help me. main_program: Warning: the value of the PWD environment variable (/apps/etl/dsadminscripts) does not appear to be a synonym for the current working directory (/apps/Ascential/Projects/edw). The current working direc...