DSXchange

Enterprise edition with LOAD option uses the Fast load mechanism and OCI uses the SQL Loader. From Google, SQL Loader is seems to be faster that the other mehods.

So you have left downstairs guys deserted for all these days.

Do you mind sharing the mechanism that you used to find the change in source. Is it trigger?

Ok, now you can reveal the trade secretes of Craig in his work place.

Its not only trim, but the pattern that you use to convert.
"%yyyy-%mm-%dd %hh:%nn:%ss" is what you had given, but actual current pattern is no '-'s delimited.

You can get the access to read all these content with less than 30cents a day. Which will let you to access all the post and many other features available in this site. By the way, if your problem is to just populate some value in Teradata during load, you can use database function SYSDATE to load w...

Column Import stage will do the work in same job. Still it should again comply to the given metadata. Those records which are reject due to wrong metadata wouldn't be possbile to capurte. But yeah, it can be simply changed to varchar and later a Transformer can be added and the data can be manipulat...

Infact its responsible for the DBA to maintain all the previlages in an ERP system. Its obvious that ERP will be used my many other system than its own. And those system which deals with DML operation in the system will certainly require permission to certain level. Its impossible to get details of ...

chulett wrote:Exactly. Let the stages generate the sql. Use a Timestamp datatype for the Oracle DATE fields. You'll be fine.

Iam following your commandments Father.

As per Ray, change in the current method on what Narasimha using would be to use Surrogate key for non-Key columns as well. I would assume here the creation of Surrogate key is, kind of creating a CRC for all the non-key fields, rather than concatenation of all the fields. So Narasimha and Craig are...

It might be a user defined function used in your site.
You need to convert it back to oracle format while loading it. You need to use TO_DATE() function.

So its our Father the root cause of this Hijack (not me).

Try avoiding Quote characters like single or double ', " if you have any. As noted, if its written properly, it can be easily opened in Excel, despite that, you can open the file specifying the respective column details.

I've got an old rule for supporting others - Assume Nothing. Sorry, I should have done that here, we would have gotten through this a wee bit quicker.

Iam perfectly in this category

You will be ended up in not using Oracle stages, as simple as that. You would still able to acheive all the functionality through stored procedures are script and it been called via Datastage, but by this you ultimately loose the efficiency of High speed capacity of Datastage.

Were you able to connect to DB2 from command line using Connect to option?