DSXchange

Hi raghu

thank u
my job design look this.i am applying rules in the transformer.

dataset--->join---->transformer----->seq
|
dataset


thanks
sundar

Hi Arndw,

Thank u for u'r reply

my Target columns are nullable.

i have one column which is char(1) in source
char(2) in target
so i concatenate with " " to make char(2)

will cause the problem

please help me


thanks
sundar

Hi All From source 83 records coming to transformer but out of the transformer only 2 records are coming,no records were rejected. I am getting the following warning APT_CombinedOperatorController(3),1: Field 'pt_state' from input dataset '0' is NULL. Record dropped APT_CombinedOperatorController(3)...

Hi Ray

Thank u For u'r Kind reply

my job design look like this

seq1 ----->transformer -----> seq2

to verify the data i put peek stage(reject link) in seq2 and i am getting ******** in the director

please correct me

Thanks
sundar

hi ashwin

Thank u for u'r reply

i tried what u said,below is the code.

StringToDate(DFloatToStringNoExp(DSLink2.a,"0"),"%yyyy%mm%dd")

it's showing the field has import error and no default value

thanks
sundar

Hi all source Sequential file field is Double, Length not given Target sequential file Field is Date and length is 8 it is a 1:1 mapping I used the below code for conversion,It's giving null value StringToDate(DecimalToString(DFloatToDecimal(DSLink2.a),"suppress_zero"),"%yyyy-%mm-%dd&...

Hi all I had two date fields valid_from and valid_to having values 29-5-2005 and 5-6-2005. i want to generate records for dates between these two fields like 29-5-2005 30-5-2005 31-5-2005 01-06-2005 02-06-2005 03-06-2005 04-06-2005 05-06-2005 if it is saturday or sunday, it should not generate recor...

Hi Ashwin, Thanks for u'r reply. lookup_fileset | dataset_1----- lookup-----transformer ---dynamicrdbms | (reject) transformer | dataset_2 when i use lookupfileset for lookup, the partition tab shows The currently selected link is a reference input from either a lookup fileset stage or a stage that ...

lookup_fileset | dataset_1----- lookup-----transformer ---dynamicrdbms | transformer | dataset_2 Hi, I have used the above job design in my project and used ENTIRE partitiong in lookupfileset and AUTO partition in the dataset_1,will it affect the performance. Thanks sundar

Hi Arndw,

For the first time i want all the jobs to run.When i run the sequence for the second time onwards, it should skip the second job.

With Regards,
Sundar.

Hi all, I am having 5 jobs in the sequence,I want all the 5 jobs to run first and for the second time,I want to skip the second job,its working well for the first time with execution action reset only and for the consecutive run it gives a fatal error.Is there any option to do this. Error calling DS...

Hi Williams, Thank you very much.I am trying to use a user-defined sql in the update action. I am able to insert if i use a query like insert into table1(field1,field,....) values(:1,:2,......) but i want to insert the sequence generated by database for each row if i use a query like insert into tab...

Hi all I have created the surrogate key in database(oracle) using sequence.I have imported the Sequence value in the datastage using a table with the query SELECT seq.nextval,B.DUMMY_SEQ.NUM FROM DUMMY_SEQ and i am getting surrogate value in the DS how do i integrate this in to the target with regar...

Hi ArndW,

Thank you very much.Its working fine.Only one problem I have is the concatenated file is getting created at the repository(ie inside my project folder).Kindly let me know if I can do this to get it created in other folder.

Thank you,
Sundar.

Hi, I am having a shellScript which appends two files into a another file. The script has two parameters file1 and file2 and I am appending to another file say file4.I want use this script using my ExecSH routine in my transformer before sub routine. the Input value I am passing is sh D:\\folder1\\s...