DSXchange

I am trying to do the follow

if isnull(in.col2) then (in.col1) else enter default value of col2

I defined the default value of col2 as default which is NA

but when i ran the job it is not entering the default value

Hi Carter

I tried outer join in merge, but was not sucesful.
I am using tables as the source. It is giving error as invalid file name

Thanks for all the suggestions

I was able to accomplish it. I did not trim of one key column. Now i am having one basic doubt. My Target is a sequential file. I developed the following in a single job and executed it. How do I see the output. One is reading x rows and other is reading y rows. How do I see the output of outer join...

I think a transformer stage cannot get reference input from sequential file

How to overcome this lookup..Any suggestions plz

I tried using the previous solution

My transformer stage is getting primary input as well as refernce input from tables. It is not reading anything from reference table. The job is not giving any errors. What might be the reason?

How to accomplish this task in MERGE STAGE

Hmm...Little more ideas

How to perform a full outer join in Datastage Server jobs. I am having two tables. One table is populated from flat files. One table is ERP(SAP) table. The ERP table is having keycodes and descriptions. The normal table is having some extra keycodes. I want to perform a full outer join. How to accom...

I got it..

Thanks

Thanks for the reply.
yes, I want to remove only X.

How to do it. can you give an example

Hi

I am having a key column like
888888X
988888X
sgahjhasjk
737326X

I would like the output to be
888888
988888
sgahjhasjk
737326

ie only keys which end with X in input should not have that X in output

Hello Whale

I posted it as it is related to the previous discusion.
By the way I am new to group and I really donot know that, this should not be done. I am sorry about it and will not repeat it in future

No the tag does not repeat