DSXchange

Hi All,

I `m getting Abnormal Termination of stage Detected Error .any one help me Regarding this.

hi
while i am loading the data in to target i am getting this is follwing error
CIDocData operator=(char): String too long for field .
and my input column type is varchar and output olumn type is char

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 hi , u can use if substrings(sttring name,len(string),length(string))='x' then substring(string n...

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 hi , u can use if substrings(sttring name,len(string),length(string))='x' then substring(string n...

Hi all, I have a doubt like can we use our source as DB2 API stage and target as ODBC stage ? will it create any problem with the table defnitions?please let me know the answer for this............ Thanks in Advance. Regards, kumar. Hi Skumar, the thing is table definations must match in both the s...

pradkumar wrote:Thanks for all the suggestions

Hai pradkumar,
merge stasge is there in server we can use this stage also . instead of hash file .(In merge stage they r so many joins are there v can perform it in merge stage.)

pradkumar wrote:How to overcome this lookup..Any suggestions plz

Hi PradKumar,
I think V can use HashFile as a refference lookup and v can match Both primary key links(from hash file key and source file key) in transformer stage.
Regard`s
Shrini