DSXchange

Hi I have used 14 files to join using intermediate Links and it works fine. I too used a left outer join and derived not only the key columns but other columns from each of the input files as well. However, my left most file is the master file that contains two key columns and all other files contai...

Instead of "Load", select Write Method as "Upsert" and choose User-defined Update & Insert as the upsert mode. Now edit the Insert query as per your requirement.

Hope this helps,
Thanks,
Somesh

That is true for server jobs. Phanee, could you explain how we set that for parallel job?

Thanks,
Somesh

Vigneshra, Could you please explain how to know that job has reached the last row of the input file and how to pass only the last appended row? I had faced the similar problem, and I solved it creating a new column appending each row values using a stage variable as Vigneshra mentioned. This gives m...

Hi , What are you not getting correctly, the required columns or required rows ? I have used cascading joins quite a few. No problem faced till now. What kind of join are you using ? I normally use a transformer after each join and use a sequential file to validate my output. And if my output is cor...

Hi, Can anyone suggest me how to create a multi-valued colmn in a hash file ? Column should display all the values separated by comma for a particular Key. for example : input file with three columns c1,c2 & c3 c1-- c2 -- c3 NE-- 20-- 1 EX-- 30 -- 2 NE-- 40-- 3 EX-- 45-- 4 EX-- 50-- 5 And Hash f...