DSXchange

Probably stopped mapping nullable columns to non-nullable targets.

Crazy if you don't. But not mandatory. Sometimes warning messages will be thrown if a file with a suffix is ".ds" does not contain a Data Set descriptor.

Stored Procedure stage, surely?

At least most of the time. A stored procedure that deals with a recordset might be included in a database stage type, such as ODBC stage.

Designer is a multi-document interface, so you can have more than one job design open at once and run only one of those.

On the other hand, if you have two data flows in one job, there is no way to run just one of those unless you include parameterized constraints in each flow.

No. Most operating systems won't return nanoseconds in any case. You can always generate "zero" nanoseconds by appending the string ".000000000000" to the timestamp.

Put the mkdir commands and anything else into your great big master control sequence.

Use a query language that includes a RANK display function.

This is not a task for an ETL tool.

The descriptor file IS the control file. There's one of that. As well you get one or more "segment files" per processing node. When you use the Data Set Management tool, and select one of the nodes in the top grid, then the segment file(s) on that node are displayed on the bottom grid (&qu...

As a Routine argument.

Or within your function using DSGetParamInfo(), but that will only work while the routine is being run from a job.

I had exactly the same problem today. So it's not just you. I submitted the PMR as a FastTrack call and emailed IBM to change is subsequently, pointing out the lack in the support site.

antonyraj.deva wrote:TRIML and TRIMT functions in a transformer with "0" specified as the character to be removed.

--Tony

These functions do not exist in the Transformer stage.

What are your data types?

Trim() function has options to strip from either or both sides.

Convert() would not be appropriate because it would also take out embedded zeroes.

hi, source wiil be like this: co1,col2,col3 100,a,hyd 101,b,hyd 102,c,blore if i use remove duplicate o/p will be like this:100,a,hyd 102,c,blore but required o/p will be like this:102,c,blore can any one help....... Please create a written specification about how this output is to be produced. Is ...

"~" is the highest code point in the ASCII range. So any ASCII string larger than ten of these must have more than ten ASCII characters. This is an expression that the Filter stage will accept.

Your auto-purge setting needs to be set to keep not fewer than 10 runs.