DSXchange

Thank you Chulett! Will use the process as given below. Thank you BI-RMA! I did creates web services in Information services Director but I think the WISD input with be waiting for single records each time from all the fields. But my scenario is reading complete file at a time which is .CSV...Please...

Thank you! The file will be on the same DS server, the scenario is When ever some one clicks a button on GUI a file is uploaded on the server and as soon as the file appears the DS job should read the file and do some validations load it into DB. 1) when you said another sequencer....so the job shou...

I am trying to build a sequence job with the below requirement A parallel job has CSV file as source and after some transformations the data is loaded into a table. In the sequence job I need to call this parallel job but the constraint is I need to check for the file in a directory on other server ...

Thanks very much!

Only information given was the files are in the DB, not sure how they are stored.

Will get back once I get the access today or tomorrow as that will give a clear idea.

We were told by the user that there are around 1000 text files which has header, detail and trailer in all the files. These files are placed in SQL server DB, access will be provided to their box where these files are present. They all are of same layout, I wanted to know how do I connect from DS to...

Hello,

The source for a DS job is a SQL server which has text files on the database.

Which stage would be the best one to access the files on the database?

Thanks

@Priyadarshikunal Order does not matter @Chulett ok, I will use wild card like filename*.txt so that it pulls all the files. When loading it does not need to be loaded one at a time, new files can be created all at a time. I will use looping if they need to be loaded one at a time in sequence, if th...

Hello, I have a job designed for reading data using sequential stage where I do some transformations and load to new file. I have around 2000 files to follow the same process, they all have the same layout and they are dated depending on their arrival. Is there any processto automate this in a paral...

Hello, When scheduling 3 or 4 jobs at a time, the jobs are getting aborted due to the reach of threshold value? I assume it is the time given for the processor to reach it and if crossed the time the jobs abort. Which way is suggestable to make the joobs run in a better way. Should we increase the t...

Thanks very much for all the input, I will find out on which DB it has been placed and connect with the appropriate connector.

Thank you Ray!

Thank you Chulett.
I assume that I can use the ODBC connector is the QC is known relational database.

Thanks Ray, so is it something we need to purchase from HP as a pack?


Thanks Eric, If it is Oracle or MS SQL server then we use Oracle or MS SQL DB stages in datastage...right?

@Ray, Thank you!

So if we do not have Driver for QC, can we get it from IBM anytime?



@Chulett

Yes, it is Quality center from HP

We have a requirement to extract data from QC database.

Please suggest which stage will be appropriate to extract data from the QC database.



Thank you!

Thank you Ray When I see the CPU usage for each stage in the performance analysis...I see that some stages the graph is in red color and some in blue color. The size of the graph shows how much performance is utilized which is clear but why is there a color difference between stages? Is there any sp...