DSXchange

How, exactly, are you attempting this connection?

Or a looping Sequence job. The Wait For File stage without a wait can just check for the existance of a file and then you could 'sleep' for 15 minutes. However, it doesn't support wildcards so that will play a role in your decision as to the 'how'. You could always write a simple BASIC routine to us...

Yes, two types: CDC and CDD. I've always known the latter as Change Data Dectection but the description still holds. CDC happens at the source while CDD is performed 'outside' the source or at least outside of any official CDC mechanism.

Pretty much exactly the same, which a little bit of time spent with the documentation would have revealed.

connector is a stage in version 8.0 but how do we configure it, what are the files that need to be modified. Connector is a stage that is documented as well as just "in" version 8. And you may still need a client installed if you choose to use 'thick' ODBC drivers... the 'thin' ones do not require ...

"will you please give me a detail description about the whole process for ETL developing using DATASTAGE" That's a pretty tall order and not exactly what we are here for. Seems like your best option would be to get your hands on the "Developer's Guides" pdf manuals that ship with the product. There'...

Nope, you'll need to roll your own here as well.

Sorry, but you are going to have to rephrase that, perhaps narrow it down a bit. I (for one) have no idea what you are asking.

Don't be thrown off but the artifical classification of the stage in the 'Development' branch of the repository. As Ernie notes, it has a purpose and while it certainly can be used for dev/debug specific purposes, if the stage solves a production problem and you are aware of any pros/cons, who cares...

Sorry, don't know anything about DB2 but I have similar fun with Oracle bulk loads on the Server side. Nothing about sqlldr having problems is considered fatal it seems, except perhaps if it can't find the control or data files it is looking for. Once it starts loading, it is perfectly happy to crap...

That would be the 'native' connectivity I mentioned and that Ray discussed in his second paragraph. The documentation for both the stages and the product in general lay out the configuration changes and clients needed for each stage to function properly. For example, Oracle requires a local Oracle c...

vrishabhsagar wrote:Shouldn't row gen be used only for development/debugging purposes?

No.

Educate them. There is no space.

Not nearly enough information. What database? What kind of connection - native or ODBC?

Ask whomever supplied you the zip file for the missing bits.