DSXchange

[quote="kandyshandy"] Next question might be how to do this? Auto partitioning takes care of this in most of the stages but we might be forced to do hash partitioning for some cases where each partition may not have "likely" same no. of records. BTW, what are you trying to achiev...

Kumar_s, I understand you say.. Prefer single node config for simple design jobs like below.. text_file->transformer->database or database->copy->database which donot have much transformation. How can we increase the performance of jobs having simple design ? other than playing with array & tran...

You can find your answer in this Thread.

Thanks Craig, [b]My second question was to only to know more about first question.[/b] And the thread I was looking was marked resolved and I doubt that new reply was added in between the the times I checked. I totally agree that premium account is only meant for viewing premium content and not for ...

I have a question related to premium content and donot want to start a new thread for this... 1) I have a premium account, I see the premium content marked on the side of the replies and I think few of those replies can be seen as a participant. I mean not all premium content marked replies are not ...

Oracle Dbase password got expired and was in grace period.

Thanks for Helping.

Hi, I developed a job which creates a file with date appending its name. something like filename_2008-01-15.txt filename_2008-01-08.txt so on.. I have used a notification activity stage in sequence job and would like to attach these files. how do I do that ? I tried using Job parameter pram1 with va...

I should have thought #$EnvironmentVariable# is what's required - which would also explain the 'unexpected "$"' message. ... now I am getting error as Incorrect dboption list; it failed on Expected "," or "}", got: "#", line 1. when I run job again its giving...

Double check your password field. It shouldn't display anything like "#$password#"; it should always have something like "******" especailly for PX job. I defined password in environment variables and there its value is encrypted and displayed as ******* I am using that environm...

Minhajuddin wrote:$ is a special character and you can't use it just like that in your password.
The documentation mentions what you need to do when you have special characters in your password.

I am using evironment variable there, not '$' as a character in password.

Hi, I created a job with Oracle stage as source in EE 7.5. In Oracle stage properties were set as Output>Connections>dboption mode>auto generated and I defined db password in environment variables. so it generated Connection>DB Options={user=username,password=#$password#} when I run the job it abort...

Hi, I am working on EE 7.5

can you tell me how to write script in unix to SFTP a file

Used like a wild card

Thanks craig, I was having same problem with timestamp and after looking at your reply used %2000yy instead of %yy and got the correct output.

ArndW wrote:I'm no sed expert, but you could put in

Code: Select all

sed -e 's/\o014/\o015/' -e "/Header Start/,/End Word/d"

...

Tried the sed command given by you, still deleting the record before the header.