DSXchange

Which is what he has... look more closer, you can't just count the commas:

Index(Sequence, ",", 1)

1st parameter: Sequence
2nd parameter: ","
3rd parameter: 1

Is this in some way related to Master Data Management?

anu123 wrote:Ray, looks like Index() take three params...Index (string, substring, instance) and you have four in there..

No, he has three.

Yah, as noted the "SCD stage" is just a shortcut, something some might call a crutch and certainly isn't needed to handle Type2 changes. I've done tons of jobs to handle that before that stage came on scene and continue to do that in another tool which has no such thing (but does have a 'w...

Image tags don't work if it doesn't know it is an image - i.e. if it doesn't have an extension like .jpg, etc. Bring the text into your post or find an alternate upload site.

Of course.

You posted in the EE forum which is dedicated to PX / Parallel jobs and you marked your Job Type as Parallel as well, hence Arnd's question. I'm going to fix both issues. Hang on...

Here we are, correct forum and job type.

Aha!

Guessing this really doesn't have anything to do with ProfileStage, so moved your post here.

Off the top of my head, seems like the Field() function would work for this, in conjunction with transformer looping.

While those suggestions can have an effect, they are not universal. Usually one has no control over the data types so one cannot unpack packed fields and thus cannot convert from EBCDIC to ASCII on the way from the host to the server. Sure... but if they are going to prepare a file for transfer, ca...

First I would verify that you do actually have to "pull" the data from the mainframe. A more typical solution would be for the mainframe to create an extract file of the data you need and push it to the ETL server, where you would then consume it. And hopefully it's "dumbed down"...

So, in other words... no.

Code tags don't allow colors so I switched you over to quote tags.

Still, I would advocate separate jobs. The file can be read simultaneously and (as noted) an issue with one load won't affect or cause reloads of the other tables. However, going to disagree on one of shiva's points: Its not a good idea to open up 10 db connections in a single job That would be an o...

So no desire to get the Stored Procedure stage working correctly?