DSXchange

Hi Everyone Goodmorning I have a source(seq file), a transformer and 2 targets one seq file and the other as OCI. I have constraints to my targets, so zero records are being written into my seq file and rest all records are routed to OCI ( about 1 million ) This job is running since 5 days for a sim...

You need to specify 1 for ' abort after rows '

Thanks Ray.

Now i'm clear the way how hashed file behaves.

Regards

Hi Saikir,

Thanks.

My question is if i donot enable preload file to memory how does a hashed file behave ?

Regards

Hi Everyone, Good Afternoon. I'm confused with the way hashed file reads the data. 1. If i use a hashed file as a lookup and i donot check option " Preload file to memory " ....does it pull all the data to memory or reads data from the physical file location for each row ? 2. If it reads d...

Hi Everybody, I need to install OracleOCILoad plugin which is not already there in repository. I donot know how could i proceed in unix. do i have a package installer in unix as well ? i already have OCI 7 load installed. but for that i need to run sqlldr command seperately. suggestions please... re...

Thanks Ray.

Issue is with the memory.

Hi, I have a folder stage which reads a set of csv files. The folder stage is connected to a row splitter. The row splitter splits the data into to rows, one the header and the other row is the data. The second column length is given the maximum 9999999 beyong which datastage cannot accept. when pro...

Hi, I have installed DSEE 7.5x2 on Windows 2003 server standard edition. The OS do not have sp1. I didn't install NLS. I have selected only pivot and sort as plug-in stages. After installing there are no groups such as DSADMN and DSUSERS created. Now i'm not able to logon to Datastage as i'm not in ...

Hi, I have a job design flat file --->xfm---->xfm---->oci My job was working fine. Now that i have changed datatype of password from string to encrypted, its throwing errors and my job is getting aborted. Unknown: DSCGetStrStageProp value (??) of property (PASSWORD) contains unmappable characters (M...

Hi, I have a Source Table in remote on which i fire a SQL and put all the result into a staging table residing locally From the staging table i do the aggregation or some selection based on where clauses etc and put into next table. Now i wanted to know instead of a staging table can i use a Univers...

Hi,

Could you please give me some idea of how can i perform a Vertical pivot in server jobs...

The scenario is:

Source File:

Col1,Col2
1,1
1,2
1,3
2,4
2,5
2,6
3,7
3,8
3,9

Target:

Col1,Col2,Col3,Col4
1,1,2,3
2,4,5,6
3,7,8,9

Thanks

Suresh N

Hi Amit,

Try this ...

If Len(Trim(Link.Column))=0 Then

Then Oconv(Iconv('99991231', "DYMD"),"D-YMD[4,2,2]") : "00:00:00"

Else Oconv(Iconv(Link.Column, "DYMD"),"D-YMD[4,2,2]") : " 00:00:00"

Regards,
Suresh N

Hi,

I gues this should help you when you put this in a batch.

C:\Ascential\DataStage\Engine\bin\dsjob -server <server_name> -user <User_Name> -password <somepwd> -run <Project_Name> <Job_Name>

Regards,
Suresh N

I can't implement either of your solutions, rather i'll go to my work.

Many thanks for your answer Chulett.

We have Single Core 4 CPUs.

Thanks & Regards,
Suresh N