DSXchange

I think your best bet wud be either:

1)Use a hashed file stage or
2) Sort the records in Unix using sort command (before job sub-routine)
and then using stage variables in the transformer, reject the duplicate
records.The addition of Sort stage will surely slow down your job.

HTH

Hi,

You can use the ODBC stage to read this excel file.Pl. read earlier posts on how tro do this.

Rgds
Sanjeev

Hi,

Try doing a Isnull(Trim(field)) and then apply your logic .

HTH

This doesn't seem to help us. The O/P we want: - <position> - <bondfwd> <Position_Name>ACGB Fwd</Position_Name> <Notional>660000</Notional> - <customBucketList> - <customBucket> <customDimensionName>Account_ID</customDimensionName> <customBucketValue>9369</customBucketValue> </customBucket> - <custo...

Hi I want to generate one xml file usinf datastasge 7.5 server job the file should look like - <position> - <bondfwd> <Position_Name>ACGB Fwd</Position_Name> <Notional>660000</Notional> - <customBucketList> - <customBucket> <customDimensionName>Account_ID</customDimensionName> <customBucketValue>936...

Hi, We have a requirement where we have to convert values from a DB table to XML.We are able to get the XML output but the format is not as required: O/P now:- <position> - <bondfwd> <Position_Name>ACGB Fwd 02-08-06 6.2500% 04-15-15</Position_Name> <Notional>660000</Notional> <Currancy>AUD</Currancy...

Modify stage has a Handle_Null function the syntax of which goes like this .. Handle_Null(<column_name>,<the value to replace null with>).However this can only be used for existing columns.You cannot create new columns in Modify stage.Use a column generator/transformer for that.
Rgds

The main difference between joiner and lookup is in the wasy they handle the data and the reject links.In joiner, no reject links are possible.So we cannot get the rejected records directly.Lookup provides a reject link.Also lookup is used if the data being looked up can fit in the available tempora...

Hi, The work tables are created each time you perform an operation using Multiload.It is automatically dropped once the job has run successfully.However if the job aborts, then the work tables have to be manully dropped before the job is run again.If your job has aborted, pl drop the work tables man...

Multiload is very efficient when you are doing maintenance activities on multiple large tables.At a time Multiload stage can perform Inserts/Updates on upto 5 different tables in one pass. If you are using enterprise stage for this , then you will need five different stage instances of the Enterpris...

Thank You for your reply.The number of rows neednot be consistent.It just turned out to be like that in my example.

Hi, How do you achieve the following in a parallel job: I have a source in the following format Id Name ----- --------- 1 xx 1 yy 1 zz 2 xx1 2 yy1 2 zz1 3 xx2 3 yy2 3 zz2 I want to get the data in the target as following id name1 name2 name3 ----- -------- ---------- ---------------- 1 xx yy zz 2 xx...

Hi Nick,
U can probably set the environment variable APT_STRING_PAD_CHAR to the char which you want to be used for padding instead of null.By default DS will pad string with null.HTH

Hi Siva, Thank You for you r reply. The polling interval in my case is about 20 secs as specified by the client. Suppose , I execute another job which writes to a file based on the polling result, will it create a dead lock situation since too many processes try to write to the same file (as the tim...