DSXchange

Can anyone know this issue....

how many no. of readers per node can be declared at max. in a job ? Is there any limit ?

Thanks AndrW

The size of File3 is 6GB. is it cause problem ? Why i'm asking is- with small file size (Prepared testdata) , without doing any modifications, the data coming out correctly from join.

( File1 :- 2GB , File2 :- 2GB and File3 :- 6GB)

I have tried with the common columns ( Col1, Col2, Col3) by giving hash partition in join stage. ... which is not helpful.

Hi ArndW Remove Duplicate stage - hash partition with internal sort option - on the below columns : Col1 Col2 Col3 Col4 Performing Inner Join on the below columns Col1 Col2 Col3 Col5 Col6 i.e. hash performing on 4 key columns, and join performs on 5 columns in which 3 columns are common as shown abo...

We are running on two node configuration and using Hash partition with internal sorting in remove duplicate stage and 'auto' is using in both joins. (JOIN1, JOIN2)

The above configurations/logic is same in two jobs (cases) as mentioned in question.

Hi Every one I have one parallel job designed as below : File1 ---> Removeduplicate --> JOIN1 --->tnf- -> JOIN2 ------>Ouptput File 2-->RmvDuplicate--------> JOIN1 File3 --> RmvDuplicate--------------------------------> JOIN2 Case 1 : File1, file2, file3 are reading normally (not enabled the propert...

Yes , I 'm using 'LF' , for getting the output what i have got : <school> <section> <Class Id="001" Type="NUMBER" RollNumber="7700"></Class> <Class Id="002" Type="NUMBER" RollNumber="7300"></Class> </section> </school> but i need <Class Id=...

Trying with notepad.. with browser it doesn't give difference for both...

Hi Every one, Good Morning, I need to generate XML output file in the below format : <school> <section> <Class Id="001" Type="NUMBER" RollNumber="7700"> CRLF </Class> <Class Id="002" Type="NUMBER" RollNumber="7300"> CRLF </Class> </section>...

Thank you ray

Hi ashishm ,

is it resolved? If so let us know how you did it. Thank you

Hi,

Try with the 2 key columns define in your input and make a sort on one key column and perform cluster on another key column it will give the different output.

Hi , According to my understanding : For Cluster key column-- sort stage itself creats the clusterkeychange in output column , and takes the default 'tinyint ' datatype. The 'sort key mode' should be in either 'Don't Sort(previously sorted/Previously grouped mode'. Cluster key mode is not ready to t...

Hi , jwiles extension : -- So The job flows as below : ********* Reference file **************| Input File ----> lookup **************| *********** Copy ---> Transformer --> remove dup --> Few other logic **************| ***********Reject file Normally Sequential File stage does not support any outp...