DSXchange

Hi, 1. Is there an option to add a ROW NUMBER COLUMN to the reading sequential file in the sequential file stage? I read and searched through the Sequential File Stage section from the Parallel Job Developer's Guide, Version 7.5.1, but didn't find any. 2. Is there any way to pass how many rows are r...

I will need to do this in DataSatge, as I am working with flat files. I was asking, "Do you have to achieve the grouping logic in DataStage?". Anyway, here's how I would do it in pure SQL for the grouping. 1. Use DataStage to read the flat files into a table, with an extra column "gr...

What is best way to handle such a task in DataStage?

FYI, the grouping logic can be handled in pure SQL, I believe. Do you have to achieve the grouping logic in DataStage?

Hi,

It's already pretty clear how to isolate the fields, but my question is how to write multiple rows into target from a single row input?

Use transformer for multiple outputs then funnel them together? Any better ideas?

Thanks

This topic has been marked "Resolved."

I was just trying to see what is the basic difference between Change Capture and Difference Stage

So have you found out yet?

thanks

Define "fine". chulett asked you to add a transformer, did you see that stage or not?

*edit* although one of my test DSX files is v8 and that seems to be ok, not noticed any problems.

good to know. thanks

Following up on a thread that has exactly the same problem as mine, http://www.dsxchange.com/viewtopic.php?p=367173 In a nutshell, after I click the Job Report tool in the Designer, I never a pops up message box containing link to view the report. I.e., "I don't ever get a second dialog box&quo...

Inspecting the Job Control code generated by compiling the sequence will answer this question for you

thanks, will do, and post back.

I've been looking at some DS8.5 DSX files and they don't look much different to me . . . I just did an import of a 7.5 DSX into 8.5 and then exported it back out again. . .

FYI, The jobs developed from scratch natively in DS8x looks quite different to me though.

... You have a job sequence running 10 jobs. You need to set a parameter to a value and then pass that value to all 10 jobs. . . in the job sequence setup a "user variable" using the User Variable Activity stage first (before the jobs). . . If your UVA stage is called SetVar and your actu...

Hi, What's the best stage to use as a dummy stage to discard link output? I.e., I don't care what the output are but I need an output link for certain stages, so I need a dummy stage to accept the output. Peek stage come first to my mind but if the output have millions of records, it will fill up th...

I don't have a DS 8 to try out myself so the waiting might be long...

My first question (based on above), about the "source data on the input link"...

Here is an image, which should make it clearer.

I've read the following over and over but still wasn't able to grasp how the SCD stage works, though I know the SCD concept rather well. "The Slowly Changing Dimension (SCD) stage has a single input link, a single output link, a dimension reference link, and a dimension update link. The SCD sta...