DSXchange

Nagaraj wrote:How about on other tools like which are coming with the IS suite

Metadata work bench
Fasttrack
Discovery
BluePrint

Don't really think so - there's already heaps of collateral on these on IBM's web site. (Except maybe Blueprint Director.)

Use a fork-join design with an Aggregator reporting the max value. Downstream check whether the max value is the same as the current value and set your flag accordingly.

Yes it's possible, but only if the target data type is a string of some kind.

Probably something to do with the multiple nodes contending with each other. Does your partitioning guarantee that each key value can occur on only one node?

Importing from XML first involves converting to DSX. The component that does this is the one that can't be found. Try it on a different client machine - if that works, it's probably an issue with the search path on the first client.

You should prefer istool (or Information Server Manager) as the tool for migrating Information Analyzer projects. The new Migration Assistant might also be useful but it has some deficiencies - for example it can only migrate into a brand new, unchanged, environment.

Would you (anyone out there) care to suggest topics of interest?

smart2786 wrote:Hi ray,

Could you please help on this??

Thanks

That is not how DSXchange works. Any people who feel they can contribute something are welcome to do so. And anyone who feels that he or she can not contribute anything useful are at liberty to remains silent; there is no compulsion on anyone.

Sampath wrote:You Can Use NUM function

Oh. Did I not mention that one? Oh.

Do you need to qualify the table name?

Sampath wrote:Use Substring [1,10]

Incorrect syntax - this one won't work.

Of course there is. Don't send duplicates in the first place.

sqlldr must follow exactly the same rules as the INSERT statement.

Partitioning only ever occurs on an input link. How the data are partitioned within the Sequential File stage will depend on a number of factors, but will typically be one file per partition if you have the same number of files as partitions. There are other properties such as "treat as File Se...

You can configure Citrix Metaframe server to map a drive on your local client. For example V: drive on the remote client machine might map back to C: drive on your local computer.

From the Available options to add field choose the "read as EBCDIC" property. (I'm not certain of this property name and am not in a position to check at the moment.)