DSXchange

Hi,
As per my understanding..part no is key and in the output there are four fields including the key...so now he wants all the data together in the output field as one(as per my understanding)...so for achieving that we can use column_export stage.

Hi,
I think you can do this by using Column_Export stage.

Thanks
Kumar.

SFDC stage?

Hi,
Sorry about this.....we don't need transformer for this....just in the lookup condition not met then fail...as she mentioned earlier.

Hi,
I am sorry...what i mean is write a User Defined SQL in your Lookup reference stage and compare both the records in the next stage that is transformer.

Hi,
how you read the XML file....before XML input stage...you should read the file as single LongVarChar field and then pass on to XML Input stage..there load the XML metadata in Output..Columns.. of the stage.

Hi,
Yes..if you are doing a lookup from a table then you can write a User defined SQL.

Hi,
Yes,...b and c are reference tables as you said... you can do a Union on both those tables and then compare to Source table.

Hi,
If you are running this SQL in DataStage .......it will not take Semicolon...remove that and it should work..

Hi,
As per my knowledge you can do both in SCD stage..

Kumar.

Hi,
Right click in your job and show Annotations........

Kumar

Hi,
You can do this in Transformer stage by using If Then Else condition..

Kumar.

Even You can use 'If Then Else' in Transformer and get the result.

Hi,
I want to convert from '-----' to '-' so for this i am using Convert function Convert('---','-',NullToValue(lnput_field,'-')) ............but i am getting empty rows in the output.........can any one please help me out with the code.

Thanks
Kumar.

Same as Sequential file and Dataset.

Nani.