DSXchange

Hi All, I have a question reated with the performance gains from IPC stages. We are using IPC stages at following places: 1. After the Source stages. 2. Before the target stages. 3. Prior to Hashed file stages (at the time of hashed file writing/creation). 4. Prior to transformer and after the hashe...

Correction :
DSJ.JOBLASTTIMESTAMP : will tell you when the job was last run on the server.
I am not sure, do we have any provision to see when the job was first created (or saved)

Yes, you can view the timestamp (last date/time modified) from datastage manager, moreover if you want to use the timestamp of a job inside a job then you would need to use
DSGetJobInfo (JobHandle,DSJ.JOBLASTTIMESTAMP) function, where the JobHandle is the handle of that job.

The Answer is yes, If pre-load to memory option is Disabled, in the lookup Hashed file.

Type 1 and Type 19 files are directories not Hashed files.

May be you have not checked the Create File option, you can see this option for output Hashed file stages only.

don't specify the condition in the where clause, specify it in the other clauses since you are using avg(salary), use having option.

Check the 12454th row of the file may be it is containing an additional quote character (") in the empid column or some other column.

You can reposition the columns from within Interprocess Stage, just right click the column to be repostioned, drag it to the position where you want it.

if you are already aware of the columns that are going to get updated, then load only the key columns + the cols to be updated without the rest of columns which are not at all updated.

My target is MS SQL Server, if I tried to populate the data through one transformer it works fine...

Dear WoMaWil Null means unknown. Empty string is not unknown. u can verify the difference by inserting '' in a not null column of a table, it wud accept that, but with null it wud throw an error. Try this in SQL create table abc ( a char primary key not null ) select * from abc insert into abc value...

Hi All, I am getting a problem regarding NULL.. I am taking ''(empty string) in one of the columns from my source, I am passing the columns from 4 transformers(for lookups) and at last I am writing them to target table.., The corresponding column in the target is not NULLable, But when I run the Job...