OraFAQ Forum: Data Integration » Create JDBC task in integration template OWB

Home » Developer & Programmer » Data Integration » Create JDBC task in integration template OWB

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create JDBC task in integration template OWB [message #563971]

Sun, 19 August 2012 07:46

lola_bas
Messages: 3
Registered: July 2012

Junior Member

I'm trying to modify the flag_useless_lines task and create a different condition for one single column in my table (the column is called TS). Something like

(<?if ([COL_NAME]equals(\u0022TS\u0022))

I'm sure this line is not good. Can you suggest me something?

{?>"snpRef.getTable("L", "INT_NAME", "W")".[COL_NAME])!=T.[COL_NAME])<?} else {?>("snpRef.getTable("L", "INT_NAME", "W")".[COL_NAME]=T.[COL_NAME]) Or ("snpRef.getTable("L", "INT_NAME", "W")".[COL_NAME] IS NULL and T.[COL_NAME] IS NULL)<?}?
)", " \tand\t", "", "(UPD AND (NOT TRG)) AND (NOT UK)")%>

Thanks!

[Updated on: Sun, 19 August 2012 07:51]

Report message to a moderator

Re: Create JDBC task in integration template OWB [message #564007 is a reply to message #563971]

Sun, 19 August 2012 17:45

lola_bas
Messages: 3
Registered: July 2012

Junior Member

The solution is something like this: (where TS is the colum name)
if (\u0022[COL_NAME]\u0022.equals(\u0022TS\u0022))

Report message to a moderator

Re: Create JDBC task in integration template OWB [message #564965 is a reply to message #564007]

Wed, 29 August 2012 14:24

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Thank you for letting us know.

I suppose you saw that many Warehouse Builder questions remain unanswered as nobody of the regulars uses it. If you have any experience with OWB and have some time to spare, browse previous topics and try to assist - I'm sure these people will appreciate it.

Report message to a moderator

Previous Topic:	Update package in Design Center
Next Topic:	OWB Vs Solaris Compatibility Matrix

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 14 04:17:27 CST 2025