DSXchange

It won't impact the existing jobs. Also, you can have the default setting for "Enable RCP for new links" box unchecked in the project level. Then you can enable RCP in job level, if required. Ya thanks it helped and now i am able to do RCP at job level. And my new & Previous jobs are ...

First you have to enable it in project level. Then a check box will appear in the job properties window. If you don't have access, ask your DS admin to do that. Note:- Please move this thread to parallel extender forum. If its checked at project level Then all other jobs will also be affected or not.

Hi All, I am designing a job: Where i have 6 Key column K1,K2,K3,K4,K5,K6. So i have to perform below steps: 1. Join data ON K1,K2,K3,K4 2. Do a Lookup ON K1,K2,K3,K4,K5 3. And then do a aggregation on all the 6 Columns. I have the join in single node running fine. But i am now implementing this job...

Hi,

It got resolved by
Putting input char in '(' and ')' .
And then putting a back-slash "\" in front of it.

But if i don't give any of this then again i am not getting an output.
So i am using both of this.

Hi All, I have the requirement to write a job which will run and read form any table given as parameter and will write it to a sequential file. And this sequential file need to be read and again loaded back to table. So i have decided it to implement through RCP. But i was not able to find how to en...

I cannot read the flowchart you posted (perhaps it is just my eyes), but the second repartitioning from A,B,C to A,B,C,D is not necessary; since for any give D to match it will already be hashed into ... I am joining through key A,B,C & D. and if partitioning is on key a,b & c. its giving m...

I cannot read the flowchart you posted (perhaps it is just my eyes), but the second repartitioning from A,B,C to A,B,C,D is not necessary; since for any give D to match it will already be hashed into ... I am joining through key A,B,C & D. and if partitioning is on key a,b & c. its giving m...

Hi, I doing two join on huge data and its one job. My job design is: Oracle 2 Left | Right Oracle-->filter --------------> Join 1 left outer V | Key:A,B,C --> Join 2 left outer V --------------> Hash Partition on A,B,C Key:A,B,C,D Rdup Hash Partition on A,B,C,D (To get max date D) I am having 2 mill...

anbu wrote:You cannot read and write to same file. Write to different file and then rename to original file

Sorry no!
i am writing to two different file;

i read you previous post as are you reading and writing to file!

Sorry

anbu wrote:Are you reading a file and writing to the same file?

Yes.
tried trim & trimleadingtrailing no success!

chulett wrote:So... no matter the input, the output you get is always "1"? ...

yes

As in input i have only that two rows separated by space.
By using peek stage i found that both columns are also read properly by column A & B.

anbu wrote:Are you getting 1 as output for all the input rows?

Can you show sample input and output you are getting?

Hi its the same input and output i have posted previously

ArndW wrote:The syntax will work as posted, thus the assumption that your output might be VarChar(1) or Char(1) and thus truncates the output string. ...

Output length is Varchar(100)

chulett wrote:Probably not long enough.

ps: your posted syntax is just fine. ...

LENGTH IS PERFECTLY FINE

ITS VARCHAR(100)
INPUT ARE CHAR(1)

SO TOTAL Character will come to 3 Char.

it does not have unicode also its plain varchar(100)

Hi, i am trying to add '+' char in between two character strings. but it is not getting concatenated instead its does not display any record in the file after that column is printed in file into the file ex : Input Rec1 : 1 2 Rec2 : 3 4 I want ex : Output Rec1 : 1 + 2 Rec2 : 3 + 4 for this i am writ...