DSXchange

Before tht we using shell scripts for job Security Purpose in tht script we are populating parameter & calling procedure now this Script we have to migrte to Windows. pls help me Imme

There are few ways to eliminate duplicates in a server job. Load data into hashed file (define the key) and load into target as hashed file will not allow duplicates. Stage variables/aggregation stage can be used to eliminate duplicates as well. HTWH. Regards Elavenil Thanks to all, How can u elimi...

Hi all,



I am new in DS. I have one doubt.My source is flat file,is having duplicates.I want to load the data to flat file(target).I dont want duplicates in my target.How can i do that?

please help.

Thanks in Advance


praveen

hi, sainath: I have to pass the data directly to db2.i have tried this format timestamp_from_string[%YYYY-%mm-%dd %hh:%nn:%ss.%ns.3](input column) ,but i got error in the transformer stage,it has shown red color. RoY: The DS version is 7.1 and O.S is windows 2000 ,ya This is sever only. please reply...

Hi,

I have sequence generated for the primary key but if I want to start the initial value from 100 and increment by 1 how can I achieve it.

Please do reply ASAP

Thanks in advance

Regards,
Praveen

Hi, I am trying to pull the data from the flat file to db2,i have certain columns wihch has timestamp as data type. during the load process encountering the error while converting string(flat file) to timestamp(db2). The format of the string value is 2005-07-07 19:19:20.0 (yyyy-mm-dd hh:mm:ss.ns). C...