Search found 23 matches

by varkashy
Sun Oct 27, 2013 6:48 pm
Forum: CloverETL Support
Topic: Invoking Transform class by passing params
Replies: 3
Views: 1246

Re: Invoking Transform class by passing params

Hi , thanks for your input.

By putting file in the class path i was able to invoke it across different sandboxes.
However, is there a way to pass params to the transform method of the class? i.e. passing params received by reformat component's input port?
by varkashy
Sun Oct 27, 2013 6:45 pm
Forum: CloverETL Support
Topic: How to pass input edge value as graph param
Replies: 3
Views: 1255

Re: How to pass input edge value as graph param

Thanks a lot for quick response.

This execute graph component, is it available in free version or is available only in licensed version?
by varkashy
Thu Oct 24, 2013 8:16 am
Forum: CloverETL Support
Topic: How to pass input edge value as graph param
Replies: 3
Views: 1255

How to pass input edge value as graph param

Hi

I am invoking a graph using RunGraph component. The input edge to this has a field, EMP_NAME. I want to pass this as a graph param to the invoked graph. In same JVM , how do i do it?
by varkashy
Thu Oct 24, 2013 6:43 am
Forum: CloverETL Support
Topic: Invoking Transform class by passing params
Replies: 3
Views: 1246

Invoking Transform class by passing params

I have a setup where in we have central sandbox and individual sandboxes. Central sandbox houses all common graphs which are invoked by individual sandboxes on need by basis. I have a requirement, where in i need to transform certain data. So my reformat component will receive 3 params, A,B,C and i ...
by varkashy
Tue Sep 17, 2013 7:53 am
Forum: CloverETL Support
Topic: Does ETL support clob and blob objects?
Replies: 4
Views: 2222

Does ETL support clob and blob objects?

Hi Guys

I have one requirement where in i need to load clob or BLOB data object into endeca data store.
From the documents i could see Endeca supports only
Boolean,Numeric,dateTime and String.

Is there a way to load image objects to data domains?
by varkashy
Tue Sep 17, 2013 7:45 am
Forum: CloverETL Support
Topic: Do Child graphs share same connections object
Replies: 3
Views: 1019

Re: Do Child graphs share same connections object

Thank you , that clarifies, my confusion was between phases and child graphs.
One more question, if i run the graphs as a transaction component how does it work with respect to connections?
by varkashy
Wed Sep 11, 2013 8:24 am
Forum: CloverETL Support
Topic: Do Child graphs share same connections object
Replies: 3
Views: 1019

Do Child graphs share same connections object

Hi I have a concern on how db connection is created for child graphs. I have a central sandbox, the db connection is created in this based on jndi lookup, and is externalized for others to use. The other sandboxes use this connection, and invoke certain components of central sandbox. Now my question...
by varkashy
Mon Sep 02, 2013 10:46 am
Forum: CloverETL Support
Topic: How to enable SQL tracing at Server level for clover ETL
Replies: 4
Views: 2289

Re: How to enable SQL tracing at Server level for clover ETL

One way i was hoping to proceed here was to create a wrapper around the class invoked for initiating DB connection by clover ETL engine and update the trace session there. Something like, before returning connection back to Clover, execute DB tracing queries. In this case for each sandbox or graph e...
by varkashy
Thu Aug 29, 2013 3:21 pm
Forum: CloverETL Support
Topic: How to enable SQL tracing at Server level for clover ETL
Replies: 4
Views: 2289

Re: How to enable SQL tracing at Server level for clover ETL

Hi What i mean was DB tracing. The below link specifiy what i want to do. http://www.orafaq.com/wiki/SQL_Trace http://docs.oracle.com/cd/B10500_01/server.920/a96533/sqltrace.htm Basically i want to create .trc files, to trace the SQL query and track the efficiency of how DB is being accessed by ETL....
by varkashy
Thu Aug 29, 2013 3:18 pm
Forum: CloverETL for Java Programmers
Topic: How to pass set of records between two graphs
Replies: 3
Views: 1442

Re: How to pass set of records between two graphs

Hi

Thanks for the inputs. Both sound interesting way for me.
For JMS way , could you elaborate? I need to open a listener for that , how does it work ?
by varkashy
Wed Aug 28, 2013 10:17 am
Forum: CloverETL for Java Programmers
Topic: How to pass set of records between two graphs
Replies: 3
Views: 1442

How to pass set of records between two graphs

Hi I have a requirement, where in i have a central sandbox which is being invoked by different individual sandboxes, the idea here is to avoid redo the same code changes at multiple places. However, what the above design is causing a kind of issue. Basically the individual sandbox will read a set of...
by varkashy
Wed Aug 28, 2013 7:41 am
Forum: CloverETL Support
Topic: How to enable SQL tracing at Server level for clover ETL
Replies: 4
Views: 2289

How to enable SQL tracing at Server level for clover ETL

Hi I was working on few sandboxes on a clover ETL server. I enabled SQL tracing and had to do that for each individual graph. I was wondering is there a way to enable SQL tracing at server level or in other words at global level as a property or something, instead of adding dbexecute components in i...
by varkashy
Mon Aug 05, 2013 7:39 am
Forum: CloverETL Support
Topic: What shall init method return?
Replies: 1
Views: 3276

What shall init method return?

Hi The definition of init method in all joiners and transform component is boolean init(). Can somebody clarify on the significance of this return object? Do i return true or false? What would it be governed on? I expect if i dont see any error in init i shall return true , is that correct? Also , i...
by varkashy
Fri Jul 19, 2013 6:17 am
Forum: CloverETL Support
Topic: Does clover ETL supports materialized views?
Replies: 1
Views: 938

Does clover ETL supports materialized views?

Hi
I am having a materialized view with an attribute DMLTYPE$$ , however, when i use the same in clover ETL i get an error as the validation error is "DMLTYPE$: invalid identifier" . Could you tell me how to proceed?
by varkashy
Thu Mar 07, 2013 11:43 am
Forum: CloverETL Support
Topic: Include parameter file in workspace.prm
Replies: 1
Views: 1051

Include parameter file in workspace.prm

I have a clover ETL project. I want to define a parameter file with all parameters and their values defined may be inside the project or outside on file system. Have an include directive in workspace.prm file, that would import the parameter file to the workspace at runtime. And access the parameter...