DSXchange

Here are the steps, which you can follow to release locks.. 1. Login as dsadm. Test into your UNIX machine where DataStage Server is installed. 2. cd into DataStage home directory. You can enter "cat /.dshome" to find the DataStage home directory. 3. Enter ". ./dsenv" (i.e. .space./dsenv) to source ...

Do a join based on first column in the Left file and second column as key in right file. Make sure you rename the columns and datatypes to be identical.

Still wondering why comma didn't worked for you.

Its was in my favorite.

If performance squeezes, you can approach single job to avoid multiple read.

It depends on how well you search it.
Click here.

Yeah, I think even I was part of one discussion. Infact I was the the victim. Where my comments where criticized to hell. I am curious, if CRC32 doesn't fit for this option, where else it been used.

Is it one staging table to 6 different table or 6 staging tables to 6 other tables.
If its the first case, the option speaks about populating the 6 target tables.
If i understand properly, But the first approach involves loading the staging table as well. Pls clarify.

Does ODBC require Oracle client installation default folders to establish connection. As I could see that dsenv should be set with same Lib path.

May I know, what you mean by "When I read the file in parallel"?
And let know that, where are you looking for all these data?
Through view data or in server?

Hi and Welcome aboard :D !!! It has been discusses lot of time. Search will give you very good insight. It will also be locked if the log file is locked by other user via Director. It might also be locked by abrubt shutdown like connection break down of the client in previous attempt. You can clear ...

Kenneth, would ODBC help by any chance in this case. I am as curious as OP.

Perhaps I ll wait till Ray or Kenneth or some one to give more details. Because it happened to me in my previous site, where I often bounce the server to avoid all this issues. As atleast I should clear up all the locks before bouncing.

DSguru2B wrote:I told you I am slow this morning

Woke up late in morning and rushed in traffic, rushed in parking and rushed up in lift and atlast felt tired and become slow in work?

Or probably the Display option mentioned was in the column select option available in PX.