DSXchange

This is more of a solution question than a DataStage question. We have a requirement as follows: There are two or more source tables each having different load frequencies(meaning these tables might get refreshed on different dates). Now, these two sources load the same target table. The approach us...

NonNullField : int32 = handle_null(InputField, 42) Forty two is the ultimate answer to life, the universe and everything. ... Hmmm ...I would greatly appreciate it if you could elaborate a lil bit more on this Ray.. (not on the The Hitchhiker's Guide to the Galaxy bit ;) ) Can i incorporate this in...

Yeah it is a non nullable column. But can I set this null default value to something else? I would like to set the integer value to something other than the DataStage default 0.

Thanks

Hi,

Is there anyway to set the null value for an integer column which is an unmatched row from the update link of a Merge stage(in Keep Mode)? As of now , all integer columns of unmatched rows are set to 0. Is there a way to set this to some other value?

Thanks in advance

Hi, We have a requirement as follows: A surrogate key (primary key) needs to be generated for an Exception table. Our jobs reference a shared container which inserts this surrogate key (using surrogate key generator and lookup to MAXVAL) into the table. But this inhibits us to run our jobs in parall...

Hi check if it is empty string sanjay What function are you using? There is an error in the Parallel Job Developer's Guide where it gives the Transformer stage function NullToValue() for the Modify stage. The Orchestrate ... I am using the handle_null function. The specification mentioned in the mo...

What function are you using? There is an error in the Parallel Job Developer's Guide where it gives the Transformer stage function NullToValue() for the Modify stage. The Orchestrate ... I am using the handle_null function. The specification mentioned in the modify stage is : Col2:string = handle_n...

Merge stage requires at least two inputs and the same number of outputs. Is this not your entire job design? ... Yes its not my entire job design, Lets just consider , the rest of my job is after the modify stage. The problem is that when Lookup is in 'Continue' and unmatched rows are output, the n...

Modify stage is not required. Remove modify stage and connect SeqFile2 to lookup stage.Set null field value of the SeqFile2 to '?'. Thanks for replying balaji ... My bad .. its actually not a SeqFile. I was just using it to see if the null value is being substituted. In actuality i have a merge sta...

Hi I have a job design that looks like : SeqFile | | DB2 -> Lookup(continue mode) -> Modify Stage -> SeqFile2 The Lookup stage is in continue mode. The Modify stage has two specficiations : 1) Keep Col1,Col2,Col3 2) Col2:string = handle_null (Col2,"?") Now Col2 (the non key column from Seq...

Merge Stage (in Drop Mode) = Inner Join

Yes, the merge stage has a reject link. The reject link carries rejected update link records.

Yeah i can create a touch file. Like i said in the earlier post I have write privileges in the /data folder. And yes '/data' does exist.

Hi, I'm facing a problem during the compilation of a job. The job fails to compile and when clicking on 'Show More' , the error displayed is ##I TFSC 000001 03:14:03(007) <main_program> APT configuration file: /opt/IBM/Ascential/DataStage/Configurations/default.apt ##W TFAR 000000 03:14:03(008) <mai...

If i have a field defined as NUMBER (no precision,no scale) in oracle database, what should be the default value to be given in datastage? I faced a similar issue... You just have to change the SQL Type in your stage to Decimal(38')'.. No need to mention the Scale. This should remove the warnings.

Hi everyone, Well my doubt is surrounding the File Pattern property of the Sequential File Stage. The scenario i'm dealing with is like this: There's a file TestControl.txt which contains the list of files present in the same folder. TestControl.txt looks like: Test1.txt Test2.txt Test3.txt The job ...