DSXchange

I have Input file which has a TimeStamp Column , All the values are in ET timezone I want to convert this time stamp to diffrent time zone based on the Local Time Zone Column My Data in file is Time in 24 Hrs Clock Customer Customer_timezone TimeStamp ET 123A ET 2008-04-09 10:20:23 124B CT 2008-04-0...

I am using in bulit procedures..

We are extracting data from SAP R/3 system and loading into DB2 database using BAPI Extract. We are having problem with BAPI extract row limitations. Looks like BAPI is limiting the result set automatically to 100 rows. Job is working fine with fewer records( <100). When ever my BAPI extract job is ...

I clould resolve this issue

I have deleted the tables from Maintain Dictionary and reload the tables to the same database and initialized the database

Cloumn analysis worked


Thank you

We have 43 tables in our source database I have imported the Meta Data into the PS, when initializing their are some errors which are ignored and started column analysis the data in each table is in Millions I could do analysis for 40 tables with out any problem, for three tables I couldn't do the c...

We are extracting data from SAP IDOC extract and creating fixed width file with NLS UTF 16BE. It is not actually creating a fixed width file all the space are trimmed. My output file has three columns Col1 Char(08 ) sample value IBMC expecting length(08 ) Col2 Char(20) sample value CUS56UT expecting...

Doesn't matter. All you lose in that case is the ability to do what's called Transaction Grouping, nothing you need to worry about for this it seems. Thank you This Jobs are designed by Some one and all left to diffrent project in same company and I have to Rock and roll on this Jobs from the day o...

That's your call. We generally stick with 0 to get an all-or-nothing load. You need to decide what's appropriate for what you are doing and how you are handling restarts after failure. If you do use something other than 0, make sure it's a multiple of the Array Size. One more Quick Question what if...

That's your call. We generally stick with 0 to get an all-or-nothing load. You need to decide what's appropriate for what you are doing and how you are handling restarts after failure. If you do use something other than 0, make sure it's a multiple of the Array Size. Thanks A TON Craig Appreciate I...

chulett wrote:If you are using two database stages for your Insert and Update links, switch the job to use a single stage for both links. This will keep all work in a single transaction and generally avoids all that pesky 'hanging'.

Thank you

In this case what TRANSACTION SIZE is best option

What is the db you use[try merge statement if you do], hanging issues cannot be answered without tracing your design ORACLE 9I Design is I have source and we do lookups on couple of table and look up the same Target table If the record is a alredy exists then We update the table and if new record w...

chulett wrote:How large is 'large'? Editors like UltraEdit32 can handle very large files and on UNIX you have functions like 'sed' to do that. Very little pain involved in either of those.

Thanks a TON it worked

chulett wrote:Well, one such way would be to edit the .dsx file and change all occurances of Readonly "1" to Readonly "0" before importing.

Thank you

This works but when you are dealing with large size file doing the Replace is a pain

Any other smiple way

Thank you

Hi All


I have exported a DSX from PROD Server where Jobs are READY Only and I'm Importing to DEV Server After I import the Jobs are still read only in DEV How do I get Around this

I need the Jobs in DEV to be in EDIT mode

Your help on this will be appreciated


Thank you

Sometimes this is caused by not having write permission to the folder on your client machine where the XML document is to be written. Otherwise, there is something in your job sequence that can not be found in the Repository. Check with your support provider as to the meaning of error code 2017. Th...