DSXchange

DSParams holds the total varibles of Datastage including adminstrator client. As mentioned "Environment variable settings:" will be 2nd or 3rd depends on your setting. You can find the value passed to the job for each variable.

Thanks for the repsonse.
BTW I actually ment Informatica uses 3rd party database like oracle to build and maintain its repository.

No I mean update using UPDATE command. Because it ment that the records with the same primary key is already present in the table and hence the update action is takin place rather than insert. And BTW the record you insert shouldnt be inserted due to refrential integrity constriaint. Are you trying ...

Perhaps to Dsxchange :D

Just try to rename the column and execute once and try to view the fileset contol file from unix prompt just by cat fileset.fs, and make sure the renamed column is getting reflected in the control file.

If there is a need of transformer, it is always advisalbe to accomplish all the logic in the same stage (not overloaded) inorder to avoid the additional buffering of data, memory usage, disk usage (IO).

Not sure whether Server jobs is also a victim of fork lock conditions. Also Iam not that experience in server jobs with the design of writing into the hash and reading from the same stage in the same job. Perhaps experts can comment. But do you mean to say that by removing hash2, i.e., connecting tr...

Ooff... a quick response...
Are you sure you are lookin after the output directly after the transformation and not after any join or merge where the null will play a vital role.
Try using debugger to know rows wise processing.

Hi and Welcome Aboard :D This forum has nearly 20K topics. If you search you can find a lot of information related to your queries. Infact more that you need. Pls do a search of dsjob a command though which you can call the ds jobs. Also pls go though the given doumentaion to know about the compilat...

If you concern is more into processing efficiency you may try using Modify stage instaed of transofmer stage.
You can find the simila funciton avialable there.

Sorry I could not view the image you attached, but may I know the use of Hash1 to transformer1?
Though the suspection is at hash2, are you able to see the progress of the rows through the performance staticts, are you able to identify the bottleneck?

And what is the functionality that you are trying to replace BASIC Routine instead of Unix script.

If I the question properly and as explained and to explain you the issue is to "extract the year and month from the timestamp".

So is the Hawk's Repository is built on a 3rd party database, and not on UV like Informatica?

Also use to do exact numerical comparision using modify stage.