DSXchange

The nested If Then Else syntax should be If [condition] Then [output] Else If [condition] Then [output] Else If [condition] Then [output] Else [output]. In your case you don't need a nested condition, I think. You can use two transformers and a funnel stage to acheive it. In your first transformer u...

The above error is due to the mismatch between the NLS settings for the job during run time to the NLS setting in the Server map. A detailed article is given in this LINK. So to view data change the NLS setting of the DRS stage to Project Default and try the 'View Data'.

The job has a simple transformation. DRS(Source) -> Lookup -> Lookup -> Transform -> DRS(Target). The job completes successfully with warnings. The first warning is: APT_CombinedOperatorController,0: Invalid character(s) ([xD1]) found converting string (code point(s): Warning: Trfm_STG_ADW_PROVIDER_...

We have a requirement to implement a Type1 SCD for SQL server database. Has anyone implemented a Surrogate key generation for SQL server in Enterprise edition for SQL server 2008 in windows environment? Can anyone suggest me the best approach for implementing Surrogate Key generation for the above s...

I still get the same error
main_program: Datatype Not Supported.
Xfrm_Inp: Error when checking operator: Could not find input field "FindingId".

These are the settings I have included in my design.
"$APT_DISABLE_COMBINATION = True
$APT_NO_ONE_NODE_COMBINING_OPTIMIZATION = True
"

I am getting the error Datatype not supported when reading a SQL server database having a varchar(max) as the datatype. Importing the table definition shows the field as LongVarChar(). I tried changing that to Varchar, nvarchar,varchar(4000),char but still cannot execute the job successfully. If thi...

Hi All I am gettin data like this ... and gettin duplicates ( in green). A B C D 1 2 3 X 1 4 5 Y 1 2 3 Z 5 8 4 C 1 2 3 K Output should be as below...to be written to a Hashed file with A, B, C as Keys A B C D 1 2 3 X : Z :K 1 4 5 Y 5 8 4 C Please forward some suggestions on how to do this. Thanks..

I have played a little after the last post. Here is what I have gotten to.. Use sequential stage to read. Specific files option, using filter I am using cat to merge the input files to a single file. It works for small files but if there is a bigger size file then it aborts with the error: Error rea...

Hi, I am trying to merge 5 xml files into one xml file. The input xml files donot have LF(UnixNewline) character at the end. So basically each xml file is a string of characters without LF. I expect the output file after merging to be a concatenation of all the individual strings in each xml. Later ...

Yah I followed what Ray said above and it worked like a charm. Only regret is why dont IBM have good documentation for things such as these? Who would dream that a Row generator will have such functionality as a Folder stage? Well if thats what it takes then thats what it is...

-MSP

I have a sample job given by the IBM support to read a XML file using a ROW GENERATOR stage. This is the part of the OSH generated: ( filename:string[]{cycle={value='[&filename]'}}; ) I have designed the same job by using the stages provided in my DS. This is the OSH generated: ( filepath:string...