DSXchange

I have the following input : sr_no 1 2 3 I would like my output to become like this : sr_no1 sr_no2 sr_no3 1 2 3 How shd I do that. Is it with Pivot ? I tried to use Pivot stage like this : Row Generator -> Pivot -> Data set Row generator is geneating those 3 rows.Then my output file was defined wit...

If I have something like :

FTP Enterprise -> Sequential File

Then also will the data not be written into the disk .

I have a requirement to process (or FTP) some files from a Windows shared drive (FTP enabled) to DataStage server.Is that possible using 'FTP Enterprise' stage.

Thanks

As we don't have any Database stage for 'SQL Server', would 'ODBC Enterprise' be fine for it.

Thanks

I need to check the presence of a file using 'Wait for File' activity in DS sequence.There need to be two different paths depending on the outcome.If the file is present, path1 has be taken while path2 if the file is not present.Now what will be the triggers I should use in 'Wait for File' activity....

Which one is better option in terms of performance :

1. Polling through Cron and calling a DS job
2. Using 'Wait for File' activity to poll.

Thanks.

If we have multiple records that need to be looked up to a web service then will it be a good design to converge these multiple records (using XML output stage) to a XML file and pass that XML to web service (designed in that way to handle the XML). Then capturing the Web service Transformer respons...

How do I generate multiple Idocs based on multiple PK values(in Header segment).I am able to generate an Idoc when I have a single value PK,but not with multiple(different) PK values.
Please help.

In a data migration project,data needs to be transferred from Legacy to SAP and vice versa.Please let me know the data control mechanism : 1. For data transfer from SAP to Legacy (through Idoc,flat file etc), how to mark the end of a batch transaction (like trigger files or any other method). 2. For...

Please let me know the difference between WebSphere TX (or DataStage TX) and DataStage PX.
When to use which one.

Thanks

Hi,

Can anyone please tell me with the advent of IBM Information Server (DataStage , is WebSphere TX is required any longer.If yes, then how the two products differ.

Thanks.

Then shall I not be constrained by the number of row generator records in the input. Say if the row generator is set to generate 10 rows then the loaded count in DB2 API will also be 10. Also, the dummy rows may not be relevant to the DB2 API stage.

I need to run a DS job that just loads some passed parameters into a table (for error logging).However I find :

Transformer -> DB2 API

gives error, as I require to specify some input stage.

Please let me know which stage is to be used (and how) as dummy.

Thanks

Then where and how do we use the Exception Handler variables (like ErrSource, Errmessage etc).

Thanks for that. Its working.

Have one more dbout. If I use Exception Handler stage in a Job sequence, how to capture the error messages etc from the Exception Handler stage. What stage shouild I put after Exception Handler to capture the error messages.