DSXchange

Hi all, when i import the metadata from the oracle tables the length is being changed by four times..eg the datatype is varchar2(30 char) is converted to varchar2(120) in the datastage.. why is this happening..and how is it happening? If my datatype and length of the column is varchar2(1000 char) it...

the reason i came to know is my datastage is in unix server and i have my login created .If i login in to the datastage with my login i am not able to create the hashed file but if i access with generic account i am able to create the hashed file

HI ALL, I have a hashed file in my job which has my tablename and system as the primary key coulmn.when i run the job once i will get an entry in to the hashed file and i have unchecked the option create file as i need to have entries all the tables that i run. First time i ran i get no error second...

thanks,
how can i check the performance?Does THE ARRAY SIZE GIVEN RELATED TO THE TIME TAKEN TO COMPLETE THE JOB

hi all,
In my oracle stage and under the arraysize what should be the normal opted length.

some say we have to put arraysize as 1
and some say it to be 1000.

Does it have any performance on the arraysize

if I am correct the delimiter and terminator are one and the same

the delimiter that I have specified is 001(start of heading)

Hi all, I take data from the oracle table and load in to different table in oracle. Here i have one column from the table which has a data type as char (1 char) and even in the target i have the corresponding column as datatype char(1 char) but when i run the job i get the following error "valu...

As ArndW said, you cannot tell datastage that my last column may contain a terminator because it is supposed to contain one. if you have that varchar 200 as your last field, there are other ways to eliminate it.[/quote] yes in this case my last column contains terminators and how should i proceed in...

Hi all , I use a sequential stage between to active transformer stage and i was asked to change the contains terminators of all columns to yesin the input stage and in the output stage also all the columns contain terminators are changed to yes but fr the last column.And if i keep the last column co...

The datatype is number 22 in oracle
but i didnot mention the precision

Hi all

while importing the meta data of the table in an oracle stage
the length of my column is 22 and under display it is shown as 24.
what actually display column will do and its importance and what is dataelement

thanks all i came to know that it is a datastage library file

where will the "DSINCLUDE" be present ?
can i go and see the file SAMP.H AND its contents because i don't what was written in it

$INCLUDE DSINCLUDE SAMP.H

this wasthe first line that was given in the routine that i saw.
I want to know the purpouse of this line.

My aim is to run the shellscript through the datastage routine activity

I wanted to knw whether this is required