DSXchange

is it something regarding 'Global Environment variable' ???????

search for vertical pivot in the forum u will find bunch of topics related to it

if u open the look ip stage u will be having 2 box top is input columns and bottom will be reference column in this box u will find condition in the second row of that box double click on that row u will find a new window open which show u 4 columns 3rd one says condition not met select from drop do...

my source is flat file delimited with pipe

is the fund_number ur primary key because we normally sort on primary keys...........

its better to format the file while loading hte meta data delimiter can be selected from drop down , check box or manually

it should be in the Datastage online document if not then go for google

using ODBC will be a better choice for ur requirement

Thanks ray, ok i can create that but how the data stage will manage it can i please explain me

Hi All , i am running a parallel job using source as a sequential file with pipe | as a delimiter but the data coming is bad like there are some carriage returns in some columns and some columns has data which contain pipe therefore DS is taking it as a new column results in rejection of records. i ...

u can use Ereplace() , Convert() or Change() functions for more help u can go through online manual

u can also search in the forum for vertical pivot or click here viewtopic.php?t=97681&highlight=vertical+pivot

u can use pivot stage

u should have the list when u get DS and its licience if not then u need to contact IBM support

make the "drop deletes" option equal false in CDC.