DSXchange

If you read the ODBC specification for the Excel ODBC driver you will see that it requires that the worksheet has column headings and is otherwise in tabular format. That is, there is no scope for header and trailer rows. Can you pre-process the worksheet (perhaps into a worksheet with a standard n...

Manually looking at the sheets, how do you identify which are header, line items and trailer? One of the worksheet looks somthing like this- Header : File Name Date Column Heading : Col1 Col2 Col3 Col4 Col5 ----- Data that goes into each of these colums Col1, Col2 ..... ------ Trailer : No. of reco...

Hi all, My requirement is to read an excel file on a weekly basis, do data transformations and load it to a database. Now the catch to it is, (1) the name of the excel file changes and (2) so does the names of tabs in them. But I use the folder stage to rename the file and write the file to another ...

Hi, I am working on Datastage 7.5. Datastage server is in Unix Solaris. My datastage server is on (Let say) Host : 1 and my source files are on Applicationserver (Let say) Host: 2 Both are 2 different Unix server. Now at run time i have one FTP stage at the Biggining i am reading the source file fro...

Hi,

I also tried Force compile but still it gives the same error. Though there are no fatel error present but it is not compiling this job at all.

Hi, (1) : is not present in the path that was just the seperator i mentioned. (2) I have also checked that the path for the .apt file is also proper. and on Unix prompt i can see that file on the given path. (3) Also $APT_CONFIG_FILE value is proper /detld1/etl/ascential/Ascential/DataStage/Configur...

Hi Just override the default value for the $APT_CONFIG_FILE parameter with any of the existing config file name and path. The problem will be solved. Hi Vigeneshra / Eric, (1) I have checked the Env. variable value for $APT_CONFIG_FILE and it is :/detld1/etl/ascential/Ascential/DataStage/Configurat...

Hi, I am getting the Error in Parallel job compilation Error is in Transformer. i have verified all the columns in input and output link to this transformer it looks ok. THe error is as follows: Output from transformer compilation follows: ******************************************************* ##I ...

look's great but i have small doubts 1)retrieves the max. cumulative of existing vehicle from the table. Also adds a flag P -- how to achive this. oracle select stmt. would do the work for u. 2)reg stage variables CumTimeOf and PreviousVehicle how to set them with current feed values ( am i sounds ...

Vehicle Name | time_on | cumulative_time_on A | 1 | 0 A | 1 | 1 A | 1 | 2 A | 1 | 3 oracle 9i stage------ ----Link collector------Sort-----Transformer----O/P Sequential stage---- Oracle 9i : retrieves the max. cumulative of existing vehicle from the table. Also adds a flag "P to each of the dis...

hmmm that makes it a little tougher. So tell me is the following o/p matches ur requirement Feed 1 Vehicle Name | time_on | cumulative_time_on A | 1 | 0 A | 1 | 1 A | 1 | 2 A | 1 | 3 Feed 2 Vehicle Name | time_on | cumulative_time_on A | 1 | 4 A | 1 | 5 A | 1 | 6 A | 1 | 7 Get the max. cumulative fr...

sad that FIX (number [ ,precision [ ,mode ] ] ) did not exist then ?! Oops!! Just thought of some pitfalls, You can define the routine as Ceil(Arg1) YourDecimalValue = Arg1 * Avoids if yours is already an int If Int(YourDecimalValue) = YourDecimalValue Then CeilValue = YourDecimalValue End Else Ceil...

I think there are couple of ways of doing it depending on your Target system. I would use a Transformer to find the TIME_ON for each record and then an aggregator to sum the TIME_ON values (group by vehicle) of the particular feed. Then I would do a lookup to the target system (i would use a hash fi...

ogmios wrote:On UNIX... no.

Ogmios

my apologies if the discussion is taken in a different direction.

So Ogmios, does that mean its possible on windows. If so how?

I turned the Inter Process buffering "on" for this job and took out the IPC stages that I had between the transformer stages and the link collector. I connected the transformers directly to the Link Collector and ran the job.

It worked