DSXchange

Hi Lucy,
If you were able to pre process, its fine. Else as the way Shane mentioned, have three streams from the transformer, each one for H, D and T.
And do a lookup in later stage for availability of both H and T.
Btw : Its 'Sort' in Datastage.

Due to the Constriant voilation, it causes execption in DB. And hence the records are getting rejected in Datastage with some warning. So they are asking you to check the voilation of the records with the master table, even bofore loading it. So that the warning can be avoided and the data can be ha...

You can use OUTROWNUM with PARTNUM if you have many streams out from Transformer.

Warning 1: If input metadata length were not given, the default value is taken as 38,10. So you need to either specify the length as 38,10 in output or 38,0 in input. Warning 2: As specified in the warning, Nullable Column 'ID' is marked as Not Nullable in output grid. If you need to maintain as not...

Check for any change in permission for the user id.

You may find some or other post to deny that transformer cuases Performance degradation. And more over, otherthan adding up this in the source database stage, Transformer will be easieast way to accomplish it.

If you are provided with the access, you should be able to read via your OCI stage as well.

If you have RPC enabled, disable it. This might help for the first warning to disappear.

If input is String format, you can use this. If it is in Date format, you can use as it is.

keshav0307 wrote:Ray
what is the input data is in 'yyyymmdd' format

"Enable job Admistration in Director" option should be checked in DS Adminstrator by the dsadm id inorder to get the Cleanup Resource option enabled for you userid.

If you are to create reports on the number of rows that been loaded and processed, you can use "dsjob" command from comand prompt with linkinfo as parameter.

Will it allow you to compile If you revert the changes?
Check if it does only in your machine or on all others? Like wise check for different user id as well.

Curious to know the restriction on Surrogatekey generator. Its an internal stage of datastage. Will they restrict @OUTROWNUM as well? You need to pick up the maximum from a table. Create a seperate job to get the max of the value and pass it to the other job as parameter. To pass it as an parameter,...

Support
Btw, even I add www, it asks me for userid and password .
Atleast it works for others.

Watch it close. Ray as mentined a aproach for your case as well. Use External filter stage to utilize the power of awk (sed).