DSXchange

I see. In this case, I will just extract the relevant portion of the input records into a defined column in a transformer and pass to the aggregator. It will be parametrized so no problem with making it generic. I will still use the schema file to load the data into he database. I will be dealing wi...

Does it mean that I can only use schema files for simple passing through of fields?
I suppose the same goes for Lookup and SCD stages?

I have searched through the forum and DS documentation but I couldn't find the similar example :( I have a parallel job that reads the source file using the Sequential File stage with one varchar column, then splits the records into fields using Column Import stage according to the dynamically passe...

I have just realized I could use the Row Number Column added in the Sequential File stage. Since I'm reading only one file at a time it will run in a sequential mode anyway.
I still need to pass the max numnber of data records, so still waiting for other great ideas .

I'm building a PX job that will processes a sequential file, containing a header, a footer and data records. I need to do reconciliation of one of the fields field in the file against a value in a footer. In addition, the job is supposed to be generic, i.e. process files with different data format (...

Sorry. Will do.

Sorry for hijacking this thread. I have a routine that validates whether a file contains a header. It's good enough to check whether the first line in a file starts with "H". My routine contains the following code: ExCmd = "head -1 ":FilePath:"/":FileName:" | cut -...

Thanks. In the meantime I have found the DSSetUserStatus. I might use this to pass the return value instead of the files.

Yes, I have checked that and it was also correct.
This week we have a proper Datastage environment being installed. Maybe I will have more luck there.

I need to build a job sequence that contains few jobs and I need to pass a value from one to the other. Job A calls an SP that returns a value. This value is used as an input parameter in the job B. How best to implement this scenario? In the past I used sequential files to store values between jobs...

Played around with this for a while and still cannot find the cause of my problem. I switched on number of reporting options hoping that it would give me more information about the actual SP call, but it did not. Maybe there is some other parameter that I should enable to give me this kind of info? ...

One other question. If I change the contents of tnsnames.ora do I need to restart the Designer, or does it reads the ora file on request?

Thanks for help anyway. I'm running out of ideas here. The environment of the server (after I run . dsenv) has the following vars: ORACLE_SID= SVNAME ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 TNS_ADMIN=/u01/app/oracle/product/11.2.0/dbhome_1/network/admin The TNS entry sitting in /u01/app/...

If tnsnames.ora is incorrect should I be able to tnsping to the SERVICE_NAME? I can, both from the DS server (VM) and my client machines.

Forgot to mention that I'm also getting the error ORA-12154: TNS:could not resolve service name when trying to import metadata via ODBC connection.