DSXchange

You can use the following logic to remove duplicates using the Transformer Stage, however for that you need to have data sorted. Before using the transformer Stage, use Sort Stage to sort the data. In Transformer Stage, take the FirstRecordVar=SecondRecordVar IncomingLnk.Value=FirstRecordVar Then i...

Hi Ray, I was just trying to look into aggregator stage scenario I came across and found this post here in the history. Is it true that aggregator stage aborts on last record every time? I don't think so as I have seen running it fine too. May be I am missing something from the statement made above....

Hi,

you have marked this topic resolved. Could you please update us how exactly you solved this?

Sorry Ray,

could you please elaborate what does "Simply use the number of rows returned from a lookup against the business days table" mean?

Ray,

It's not easy or not possible at all? As I know we can't copy datasets from one to other as it's saved in internal format which is very much server specific. Only thing possible is the solution you suggested.

Is there any way at all to copy them?

In the lookup stage, double-click on the Condition or right-mouse-click on the left pane and choose "conditions" and you will see a drop down box on the top left of the window that allows you to choose the link from which multiple rows can come. Andy, Let me give the exact example what I ...

Did you try doing that in a Transformer/Filter stage downstream? yes , so wen lookup on ID only , multiple entries are present in reference table for a ID then only one entry gets picked up and other wont and lookup stage has option to return multilple row only for one reference link. not more for ...

Thanks

Can we export or import job parameters also just like jobs?

Why so many "what is the difference between..." posts? Enterprise stages have innate parallel capability (even if it can't always be gainfully employed). API stages originate from the server engin ... Thanks Ray!!!! Reason for so many what's diff posts is just to get things clear in my he...

Hi,

What is the difference between Enterprise stage and plug in stage? For example FTP enter prise stage vs FTP plug in stage or ODBC Enterprise stage Vs ODBC Plug in?

Is the schema on Dataset2.ds is same as input as in your example it looks exactly the same.

ArndW wrote:No, that is not what Ray or I said. As written earlier, you transfer data to your DataStage job via the FTP stage then write a file from the job. ...

IT means not directly to file on other server.

Thanks a lot for explanation Arnd!!!!

ray.wurlod wrote:The FTP stage types do not FTP files. They transfer file contents directly into the job design. ...

So it meas Ray we can't use this stage to transfer file from one server to other?

agpt wrote:Thanks....

How Can I access it? Through Designer?

Sorry

Wrong question. I myself asked how to access from unix