DSXchange

Hi,

I tried running the job with null field value = '' but still the warnings are coming.

The data type is integer(10)

Regards

Kumar

Hi, I am facing with the following warning when I try to run my job Sequential_File_75,0: Field "Field008" has import error and no default value; data: {20 20 20 20 20 20 20 20}, at offset: 78 Looking at the log I can understand that there is an import error for field008, can somebody expl...

Hi, I am trying to run a parallel job where i am using seq file as a source and writing it to a data set.The job ran fine but there are some warning in the log as Sequential_File_120,0: Field "ID" has import error and no default value; data: {I D}, at offset: 0 Sequential_File_120,0: Impor...

I finally managed to get rid of these warnings by implementing cast function from the input column.

Synatx : CAST(i/p col AS VARCHAR2(50))colname

Regards

Kumar

Hi, I am just having a following warning when i am trying to run my job. Column BATCHNUMBER floating point decimal is not fully supported; adjusting the scale. I tried to import the columns from database which has a data type of number(38,10). Once the columns are being imported the data type turns ...

Hi, I am using oracle enterprise stage as a source and i am writing a user defined query which is joining on two different tables.The result of this query will be populating some 50 to 60 columns and my question is in order to define the columns in the source what is the best method to import these ...

I am trying to read data from sequential file where it contains two columns ID and SYSTEM_NAME.My problem here is the data in system name contains quotes,I need to get rid of these quotes before loading in to the target.Any ideas or suggestions around this would be really helpful.

Regards

Kumar

I have a scenario where i am running a job through sequencer and when the job is being completed it should record the current date and time in the job in two separate columns which are already pre defined.Any ideas or suggestions would be really appreciated.

Regards

Kumar

I am using datastage 7.5 parallel version and i haven't used this previously, I have a repository where it contains large number of jobs.Is there any search option for repository to quickly locate a job.


Regards

Kumar

The question i asked is regarding datastage and sorry to post my query in wrong place.I am new to this DSXchange can you suggest me where to post my datasatge queries.

Regards

Kumar

I have a scenario where i need to calculate the number of records processed from the input and pass that value to another field.Can some one help me with this logic.

Regards

kumar

I have a dataset which has some 400,00 records in it,for my testing purpose i need to create a copy of the data set with a sample of first 200 records from the data set. Can somebody let me know how to do this.

Regards

Kumar

I am trying to install DataStage 7.5 on my laptop,but it already has an existing version of 8.1.If i have to install 7.5 do i need to uninstall the existing version in order to install 7.5. Can somebody suggest me on this how to do it.

Regards

Phani

Hi,

Can some one explain what are false positives and false negatives in quality stage.

Regards

Kumar

Hi,

I am trying t understand the concepts of quality stage,can somebody please explain me what is USPREP ruleset and how different it is from USNAME,USADDR and USAREA rule set.