DSXchange

I already marked this one as resolved... which means I will open a new thread when i have more issues... Thanks Craig.

Thank you so much Craig. It worked. I used -Oxzf option and it did the magic. I should have completely read the tar manual. anyways thanks. I was also wondering does it matter if the filename field in Seq file stage can have any name and still it works? In my case i gave the file name that will be e...

Hey... i did delete my hijack post... I was badly looking for a solution for this problem and I posted my problem wherever it was related... anyways...thanks for your reply.... but the problem is i dont have the premium membership and so couldnt view your post... can anything be done without me gett...

we need to parse and transform a .tar.gz file in memory. So I used a external source stage and tried to use the following command to tar, gzip and read a specific file inside the tar file. tar -xzf xyz.tar.gz xx.tsv Its not importing any records form it. The format is fine as I unzipped manually and...

we need to parse and transform a .tar.gz file in memory. So I used a external source stage and tried to use the following command to tar, gzip and read a specific file inside the tar file. tar -xzf xyz.tar.gz xx.tsv Its not importing any records form it. The format is fine as I unzipped manually and...

Thanks for your inputs. We are currently trying a POC for the same. Will post a query if we get stuck somewhere.

chulett wrote:Somewhat. Any columns handled by RCP will be strictly "pass-through", i.e. with zero in the way of transformations. ...

Thanks

RCP could be used to some degree... but why? You want to intentionally add a destabilizing feature to your application design? Mike The input file will have few mandatory columns and few optional columns. These optional columns may differ in each input file. The order of columns can also change The...

Hi, We have a requirement where we need to identify those jobs that are impacted because of metadata change. I know this can be achieved through Usage Analysis. But we also want that if metadata changes for that job, the job should dynamically include the changed metadata in place of the existing me...

As you have mentioned how do I associate a MSAccess database to a SQL sever I am not sure exactly how it is done, although I have heard it being done. I would think it is a valid question for your DBA. Please do share with us if he/she has a solution. I just browsed through the MSDN and found this ...

Is there a way to access data from a MS Access database in DataStage version 7.5 or more? Since you are on Unix, you will have to check for 3rd party tool for connectinto MS Access. You may want to save the data in a .csv file. If you could associate the access .mdb file to a SQL Server, then you c...

Is there a way to access data from a MS Access database in DataStage version 7.5 or more?

tzeng wrote:

tzeng wrote:The qualitystage certification is out. Is anybody planning to get certified?

Finally got time to read through all the pdf, took the exam and pass it with score 89%.

whr do you get the materials to study for the certification exam???

Does anyone have an idea about the following error. I am getting this error when I run a server job that has a merge stage in it. Can anybody throw some light on it and how to resolve this error??? Function 'get_next_output_row' failed. [Input file : TMAJORCLASSSPLITRULE.TXT] End of row termination ...

The following is my issue: we have an oracle table with 4 fields as key columns. The requirement is to fetch a particular column value from the oracle table for every record in a input sequential file. But the seq. file doesnot have all the fields that make the key in the table. After pulling out th...