DSXchange

No.

I feel that the solution suggested by the first man, is NOT working and i am asking him for clarification.

The required solution is already given. Please look back all previous posts.

If not satified, refer page# 438 in Parallel Job Developer's Guide regarding Transformer Null handling.

However, will the change in the key names will have any impact on that?

No. You can certainly do an experiment to confirm this.

I have 300 jobs in my project, i have called apt_config_file environment variable in every job, this apt_config_file file path is changed every time when i migrate datastage jobs to deferent environment like QA or Production so now my problem is every time I have to open the job and change the path...

ArndW, The requirement is to export Jobs from one server to another server through UNIX without using DS Manager. I am in the same point telling you that the command line Import/Export utilities you specified are ONLY in Client systems and are used to export and import DataStage Components in comman...

ArndW, The requirement is to export Jobs from one server to another server through UNIX without using DS Manager. I am in the same point telling you that the command line Import/Export utilities you specified are ONLY in Client systems and are used to export and import DataStage Components in comman...

Though, i am not clear with your transformation as having questions - what about Input metadata before and after transformation, is it possible to seperate light weight transformation in order to make same input and output metadata for main transformation. 1. Seperate Extract, Transform and Load as ...

Thanks ArndW.

I follow it from next time.

Of course i must have a same question here . What kind of rejects do you really need to see? 1. Busines Rejects records 2. DataStage unhandled records(unless Null handling in Transformer and reject link --> record would be dropped with warning in log) Please say precisely what you are going to achie...

If you wish to export your project without using the clients, you can use the dscmdexport and dscmdimport commands. The commands you refered are in the Client only but mostly in C:\Program Files\Ascential\DataStage7.5. These commands are nothing but command line Import/Export utilities available in...

dsean wrote:You can use DS functions in the transformer to get the number of rows from a input link. GetLinkInfo().

Shall i recommend you to read this - Job reads its own link counts

I have around 100 table which has the same type of tranformation and job design. but 100 table has different metadata .

I have one question:

How the same type of transformation would be applicable to different metadata of source?

I have around 100 table which has the same type of tranformation and job design. but 100 table has different metadata .

I have one question:

How the same type of transformation would be applicable to different metadata of source?

...If you really want the row in a file, use a Sequential File stage. I dont find any row in the sequential file and the truth is file is not created in the target place and the reason i given already. Still i have been holding this question "Why File is not created" without answer? Pleas...

You are correct ray.wurlod.

I edited my post now.