DSXchange

Yes but still i am getting the warning..i replaced the modify stage with transformer stage now it work fine ...

Thanks..When i use explicit sort stage before join it works...But i want to know why its behaving warning when sorting with link?

Target datatype means both the join input or join stage output?


Note:when i use Transformer instead of modify stage iam not getting this warning...but i hope using modify stage in this scenirio is good pracitce.

Hi, I want to convert varchar(11) column to char(11).So i used modify stage to convert the datatype.I simply changed the datatype in output metadata and set the specification as NOWARN but still iam getting waring in output as below. On input data set 1: When binding input interface field "WCC_...

Yes Ray,

We are joining 2 dataset in join stage which was set as preserve partition.
We cant change in dataset since it is used in many other job with that partition.

I changed the the preserve partition into clear but still iam getting this warning..We will get this waring because we use link on sort instead of using explict sort stage before join?..

Hi Guys, I have a senario to join 2 dataset using join stage.I put hash partition and sort on link to join stage since 2 dataset preserve with different partition. its executing fine but iam getting follwoing warning.Can you please guide to takeaway this warning in log?. When checking operator: Oper...

Hi All,

One basic question what the difference between function Trim() and Trimleadingtrailing()..I hope both do the same job.

Thanks,
Gowri

Thanks priyadarshikunal and Arndrw

Thanks AndrW, One basic question..So you mean to say only sort on the same key colum alone wont work for join.even partition also should be on the same key column for both the input. In join both input will be compared like Left link input node 0 to right link input node 0 and it wont be like left i...

Hi All, For join stage i have 2 input links.Say example as below. Input 1: input -2 A B C D T U P D --------- -------- 1 2 4 5 t u 8 5 6 7 h 5 8 i 7 7 3 5 6 t 6 8 5 t t 7 5 d 5 y t u Input -1 is hash partitioned with column D and sorted with column D. Input -2 is hash partitioned with column T and s...

XMLoutput stage and inputstage are embedded in version 8.5.so you can apply the same logic in XMLstage of version 8.5 using composer.Verify the XML stage redrook.

Regards,
Gowri