DSXchange

chulett

mcs@rajesh wrote:hi guys ,
can any one tell me what is the difference between a dataset and a fileset and what is the need of using these two. And one more thing i wanna add up is what is the use of filter option in sequential file and when can we use it......

chulett

Hmm... "REST - An Architectural Style, Not a Standard".

http://www.xfront.com/REST-Web-Services.html

chulett

Dear Lonely,

Nope.

:D

chulett

To simply run a Stored Procedure every X minutes, why not just setup an Oracle 'job' to do that? There's really no need for DataStage to do something like that.

chulett

So? Doesn't tedious pay just as well as easy?

At least it's only a one time tedious. Be glad you young whipper-snappers have Sequence jobs now, back in my day we only had ones and zeroes...

chulett

If you really don't need to know the actual count, but just the fact that rows were written to particular hashed files, investigate the DSGetLinkInfo function with the DSJ.LINKROWCOUNT InfoType. A generic routine can leverage that and you can make your decision based on the row count being 0 or > 0.

chulett

I searched on 'order of execution' and got quite a number of hits. Here's one, as an example of what's out there:

http://www.dsxchange.com/viewtopic.php? ... +execution

chulett

Handle the exceptions yourself. Use 'otherwise' links to a Sequencer set to Any and then to your archival routine. Run it again after Job3 unconditionally.

chulett

Yes, you'll need to write a script to do this properly and to have the proper levels of error checking. For archiving multiple files at once, consider a 'tar ball' - a tar archive that is then compressed. And for compression, you've got 'compress' that should always be there on UNIX plus optional to...

chulett

That's the Not a Very Good Idea part.

chulett

Don't jump on the end of an old thread, start a new one instead. We know nothing about your environment or job except you are facing the 'same problem' which isn't all that informative. ps. No errrors and no output means your XPath Expressions are 'valid' but don't match the incoming XML. pps. Star...

chulett

The product ships with an 'OCI8 to OCI9' conversion utility, did you run that? Actually, as Ray notes, which OCI stage were/are you using?

chulett

Welcome. :D

How would you do this without DataStage?

chulett

Your question:

sh.bangash wrote:What I am interested to know is if this packaged ETL tool can be used for ETL purpose in telecom DWH!

All of the answers you've been given are just longer versions of this: yes!

chulett

nipun.juneja wrote:After creating the DSN, I updated the uvodbc.config file with the following entry:

You did this where? This file needs to be updated in your Project, while the former is in your DSEngine directory.

DSXchange

Search found 42189 matches

Re: DATA STAGE

Re: ODBC Connectivity through Wire Protocol