DSXchange

Why can't we use *. and *.csv formats in file pattern.

I have used the follwoing in my jobs.
SOURCE:
FILE PATTERN: #pSOURCE#/BRANCH_NUMBER/*.*

to read set of 10 text files and it has worked.

Hi, I need to count the number of rows in 10 sequential files and need to write into another sequential file. Instead of reading all the records and counting the record count in AGGREGATOR stage, i thought of using FILTER OPTION in SEQUENTIAL FILE for counting the counts. I have used 10 sequential f...

Hi,
Can any one confirm me that Oracle 11g compatiable to Datastage V8.

Cheers,

Hi, My Job has 3 input datasets, one join stage, 1 transformer stage and a sequential file. I added the Environment variable APT_DUMP_SCORE in my job. I got below information in the log ...... ds9: {op6[2p] (parallel buffer(0)) [pp] eSame=>eCollectAny op9[2p] (parallel APT_JoinSubOperator(0) in jnDl...

Hi, I need to populate the Sum of all amount fields for an account into a sequential file. In my job, i am reading the input file and passing the account number as key and calculating the sum of all amounts. The aggregator producing the sum of amounts in to a field of type DOUBLE. If i drag this dou...

I designed my job with the Keychange column property in sort stage and staging variables in the transformer stage as below. with the Key Change column property in the before sort stage i am capturing whether the key is changing or remaining same or not. And in the staging variable in transformer, if...

Hi, I am trying to calculate the cumulative sum of amounts for an account in my job. I have a file with the sample data as below ACCNO AMOUNT ================ 123 12 123 13 123 03 234 5 234 5 234 6 In the target file i want o/p to be ACCNO AMOUNT ==================== 123 12 123 25 123 28 234 5 234 1...

Hi all, I'm getting the following warning in a simple job that reads from an oracle table stage (SQL query) - sorts the data stream - bit of transformation and writes it simultaneoulsy to a dataset and a sequential file. I have ensured the partitioning to be correct all through out - the runtime col...

Hi All,

Thanks for the Replies.

I am using the COPY stage as suggested by RAY for drop the columns.

Hi, I need to drop some of the columns from Input file. I am using the FILTER stage immediately after the sequential file to filter out some records. I know that the COPY stage is the best practice for dropping the columns. Here my doubt is, instead of using another stage, can we drop columns in the...

We have removed the PIVOT stage from the job and implemented the same functionality using the Transformer and Funnel.

But the performance is not as expected.

Hi, In my job i need to convert the columns as rows. I have used the PIVOT stage for that. Job is working fine in my development environment and producing the report as required. If i import the same job in System test server and run the job, the job getting aborted at PIVOT stage and producing the ...

You can also use the following code..
Space(maxlength-Trim(In.column)):In.column

Ray,
Im able to see that when I use Aggregation Type as calculation. But I dont find it for Aggregation Type=count rows.

Thanks for your responce Ray.
I dont find this 'global Decimal Output' sub-property in Aggregator for a column for which we take the 'count rows' as Aggregation Type.