DSXchange

As you've found, that can't be done with an OCI lookup as that option is only applicable when using ODBC or a UV stage. For a 'pure' Oracle solution, I prefer to load the 'lookup' information into a work table and join that to the source table(s) so that the 'multi-row result set' is what streams i...

Hi, I am using OCI stage for reference Lookup. I need to select multiple row result set from the lookup. I tried opening the tranform stage, right clicked on the title of the reference link and choose link properties. But couldn't find the checkbox "Reference link with multi row result set"...

sdfasih wrote:Hi,
I have .xls excel sheet and I WOULD like it to be converted to .csv file.Is there any way to do it.
thanx.

Open the xl file and do a save as (.txt) and your xl files gets converted to Comma seperated text file.

Hi , I just getting the following error when i am trying to view the data ds_loadlibrary:win32 error in loadlibrary of oraoci9.dll-the specified module could not be found Comments appreciated.Thanks in advance Hi, Go to search and just give win32 error in loadlibrary and you will get plenty of views

You need to know if the job threads are still active, because the status hasn't changed on the Director screen. Telnet to the DS server and login. Use DS.TOOLS to check the processes in a job and see if any are listed. These will have to be killed if the job doesn't die using Director. Then, you'll...

Most of the Jobs having Ora 9I -> Transformer -> Ora 9i. Both target and source databases are Oracle. There will be some after sqls in the job. Datastage used is 7.0 Have you done the following steps 1.Checked for arraysize and Transaction size 2. Analysed the tables on database 3. Check for the Ed...

ysrini9 wrote:Hi All

Please help me on this how to do YTD(Year-To_Date) by using DataStage

Advanced Thank u

Regards
srini

Do you want to convert a DATE TO YEAR FORMAT , I mean 25-08-2006 and just want to extract 2006?
Then try this
Oconv(Iconv(Arg1,"D-DMY"), "D-Y")

Hi ameyvaidya Thanks for your response The Routine works fine but it is not Full filling my requirement ex1: My String : ANSY, 3/4" SQ. DR., P/N 251-A626A, Routine Output : P/N 251 My Desired Output has to be : P/N 251-A626A Ex 2: My String : BE PON AY, P/N 436A90-A602, FOR Routine Output : P/...

Explicit call to DSLogFatal would abort the job. You can use it within the stage variable. Can you clarify this. I tried using DSLogFatal in my transformer stage before but it did not work. I know we can use this subroutine in Afterjob subroutine or transform function but not sure we can use it in ...

Yes it can, and the methods can be found by searching the forum. The technique is to use stage variables to "remember" the values from previous row and to compare the same with the current row. I think you also need to be doing a similar comparison on MemTyp, based upon your description. ...

Hi, I know that this topic has been discussed few times in this forum, but my problem is a bit different. I have got four columns in my source database mno Joined_dt cancel_dt memtype 1 05/05/2005 07/08/2005 A 1 05/09/2005 30/12/1899 B 1 10/11/2005 30/12/1899 C 1 10/02/2006 30/12/2006 C 2 05/01/2006...

I am developing a server job (say Job1).Now in its Trasnformer stage derivation if I use a Routine (written by me) : MyGetLinkCount(<Job2>,<Stage2>,<Link2>) It is not creating any value for that derivation in output file,though the routine when tested from outside with the same arguments returns va...

vinodhraj wrote:Hi,

I want to truncate a number in transformer of datatype
Decimal(18,9) to Decimal(10,6).

Thanks

Vinod

Try this conversion
Left((Field(var1,".",1)),10):".":Left((Field(var1,".",2)),6)

Well no need to write a routine. Null handling can be done with in the transformer itself (for the source) and in the sql select (for building hashed files). Always have a sort of aversion towards Hash files :D .. Never got a chance to work with Hash files-may be that is the reason for my dislike ....

Hi all, I want to join two tables, say A & B, based on conditions. Say a) A.col1=B.col1 (if both not null) else b) A.col2=B.col2 (if both not null) else c)... e) nothing matches then dont join (i.e. inner join) can u help me out Regards, Asif Asif,If I were you, I will try a routine like this B...