DSXchange

... or put appropriate conditions in the triggers that come from the Routine Activity stage to whatever happens next.

It is explained in Chapter 13 of the Designer Client Guide pdf.

What ODBC driver are you using? What are the charactersets each of the databases are using?

That doesn't really explain much.

Can you spell out your requirements in words? It seems you need to take duplicate values and prefix them with a '9' and then... ???

So in other words, you didn't do the search. There are many ways to pivot and not all involve that stage.

That would basically be a "rows to columns" pivot, a.k.a a "vertical pivot" which an exact search here would reveal many informations on.

Which is what I meant by "seems" to work. Timing, especially with small volumes, can make it look like it is working but it won't 100% of the time.

OK, then there must be a significant difference in the sizes of the output datasets between the two approaches, yes?

What does your SQL look like? Is the stage generating it or did you supply it?

ray.wurlod wrote:

dr.murthy wrote:inrow num it doesnot give count the number of records

Yes it does.

So far, and the last one has the total.

Isn't the behaviour noted here related to what Michael Hester discusses in this post?

I wasn't trying to point out a typo, something I don't see btw, I was trying to point out the fact that you mentioned some kind of "failure" without explaining at all what the nature of your failure was.

Very new to XML stages or XML itself? First step would be to import the metadata for your target, either from an xsd (preferred) or from your XML file. That will get you the XPath Expressions you'll need so the stage knows how to build the output. Also, download and read the XML Best Practices docum...

Arnd, I didn't know you spoke Italian.

Siva, please edit your original post and add the particulars regarding your version of DataStage, job type, etc. If this turns out to be a Server question, no worries I'll just move it again.

You might want to explain what "getting fail at date part" means.