DSXchange

Don't believe everything you read about "performance", which is ill-defined in an ETL context. There are three stages that effect horizontal combination of data, each subtly different - Lookup, Joi ... I have often heard lookup should be used for low volume of data. Is there any limit to ...

Hi,

I know this is a very basic question about DataStage. What I want to know is when we define a field as Decimal(m,n) in DataStage, how many characters (digits and decimal sign) would the field hold?

If I have to read this field as varchar or char what should be the size of it?

Thanks Ray, I can use the hashed file now.

What if I have to copy the hashed file to a different server. Is there any command like 'scp' (works for other files) for this purpose?

Hi Sainath,

Thanks for your response. But since I am not a premium user, I am unable to view your complete answer. Is there any way that you can share the complete answer with me again?

Hi, I want to copy a hashed file from one directory to another for different projects. I am able to copy the hashed file, but when I use the copied file in my job, I get the error: Hashed_File_0.DSLink3: DSD.UVOpen Unable to open file HF_test. Can anybody tell me how to overcome this issue? Thanks i...

Thanks a lot Ray and everybody. This is a big help

Ray, Thanks for your response. I understood the different options for 'incomplete column' from DataStage help. However, I still have a query... In my job, the DC_ID is 10th out of 15 columns in the input file. Incomplete column value is set to Error for it. While mapping to an intermediate file, I m...

Hi all, I have a server job having a sequential file as source. This file has a field DC_ID with 'Incomplete column' value set to 'Error'. This field is being mapped to another sequential file in same format. But on compilation I get the follwoing error: The Incomplete column value of Column DC_ID m...

Hi,

Does all the links to a link collector stage necessarily should have the same schema??

Or is it that the schema's can be different but only the matching columns can be passed to the output link?

Hi, I have to add a reject link to transformer in parallel job and I want that whatever records are rejected on the output link (for any reason) should be passed to the reject link. I am able to add the reject link but still the rejected records are not getting loaded to reject file. The log simply ...

Hi all, I have a job design: Sequential File --> transformer --> Oracle stage I have a string field in format 'yyyymmdd'. I am to convert this string to Oracle date. The conversion is happening successfully using the function: StringToDate(Column_Name,'%yyyy%mm%dd') However, when I am using the code...

Hi,

I have a job requirement in which table data needs to be updated based on the output of lookup stage. I have to check whether the lookup is successful or not before updating the data. How can I check this?
Any pointers will be highly appreciated...

Thanks

I did just that.....but the lookup stage is not showing the reject file......

Hi all,

I need to reject records to a sequential file when the lookup fails. Can anyone guide me how to do this.....?

How do we specify an input file as fixed width in DS parallel job?
Is setting Field Deleimiter=None enough or is there any other way?