DSXchange

kumar_s

Date field cannot hold string values. But the revers is possible.
So assign it as a String fileld. And Convert back to date if required.
If the field is string your date values will be in string representation.
Now you can use field level properties.
'Null Field Value' assign "Not Specified".

kumar_s

One such post http://www.dsxchange.com/viewtopic.php? ... ight=tools
Try to drag and drop the job into sequence and do a compile and check the Job Control whether it is been reflected.

kumar_s

But what exactly the change you make and what is that not been refelcted.
Try to recomile the main sequence.
Also do a Force compile in the current job.
Else, You may need to Reindex you project.

kumar_s

For testing purpose, just try to use Trim(Feild_Name).
And verify whether you get "101 " (A trailing space ).
Have you used any NLS mapping?

kumar_s

Upsert option available in DBMS stages will mitigate the effort required. (If you opt DB as the target stages). If you go for sequential, (which can handle either Insert or Append) you need to handle the condition check seperately.

kumar_s

Yes, you need to make sure all the connection are closed. Reindexing is proejct oriented. So reindexing one project wont affect other. AS mentioned, you can find the the DS.TOOLS under the administrator client window. Use dsadm for this purpose. Goto project tab in the administrator client, select t...

kumar_s

That depends APT_RDBMS_COMMIT_ROWS. If APT_RDBMS_COMMIT_ROWS is set to 0, a negative number, or an invalid
value, a warning is issued and each partition commits only once after
the last insertion. By default it is 2000. Low in number will have performance issue due to frequent commit.

kumar_s

DataStage has its inbuilt hashing algorithm. It applies to the field you supply. Now the record is distributed based on the reminder/resultant. And it divides to the number of partiton applied. It can be something like all the numbers ends with 2,4,8 may go to 1st partition and the some kind of odd ...

kumar_s

The name explains.
It distributes randomly (with a sequence of logig applied) which may be unpredictable.
You may not be sure that you can get the same data in the same link if the input data is added with new set of record or deleted with some for the next run.

kumar_s

As that may be true, as mention if Trim used on a char field with the APT_STRING_PADCHAR as 0x0 you can find the ascii null instead of spaces.
Where as if you map the char field directly to a varchar field, you will still get the spaces.

kumar_s

Hha.. 0x0 is Ascii Null. Yes if you assign this you will get all funky characters depend upon you test editor. Now if you use Trim on Char field, all the white space will be replaced with this Ascii null (0x0). You may see those items as square of circle based on your text editor interpretation. So ...

kumar_s

But i still dont understand why you need the where condition if you want all the rows to be selected.

kumar_s

Code: Select all

select * from Sale 
Where 
SALE_TSP >= nvl((SELECT max(begin_effective_dt) 
FROM sale_history 
WHERE sale_type_code in ('5','6','7','8','A') 
AND invoice_id = ( 
SELECT invoice_id 
FROM sale_detail 
WHERE batch_id in (select batch_id from sale_detail ) )

kumar_s

Sort is not necessary for partition. The issue may be with data. If you apply the hash partiton based on the key you specified, it may likely to divide the data into three partiton, but not equally. May be more or all the data may fall under single partiton. Round robin is always good to split the r...

kumar_s

If you are able to export all the jobs in the Category individually and if not as category, then reindexing your project should work.

Search found 5168 matches