DSXchange

Thanks ray

Hi Is there any size limit in Datastage to load data? Earlier in some 7.5 version, we faced a problem of 2GB size limit above which datastage couldnt load. But recently we have 7.5.2 and we are able to load 2.7GB size data. Can you please let us know is this size limit is no where present? Thanks Sai

Hi We recently changed NLS mapping from ISO8859-1 to UTF8. We were done this to have all the international characters as specified in UTF8 to show in the table correctly. Because of this change, the following job behaving differently SEQ FILE -> TFM -> TABLE Earlier All the records were loading to t...

Thanks Nripendra

I mean the same..

I wanted to just confirm on which NLS mapping should be applied in DataStage, when database is set to UTF-8.

I got the answer.

Thanks
Sai

I was asking whether UTF-8 in DataStage is equivalent to UTF-8 in database?

Thanks
Sai

Thanks ray

Can you please tell me whether NLS character set UTF-8 would be the correct mapping, if we have UTF-8 in the database, is it correct?

Thanks
Sai

Hi We are changing our Character set to UTF-8 in our Oracle database. We are doing this to load some special characters to our changed database. To change in ETL front, we have hundreds of jobs which does loading. All are assigned to Project default. The project default in administrator is "ISO...

Hi I have the following job DB Stage-> Tfm ->Aggregator ->Hash File From DB Stage, we are extracting 3 million records and doing aggregation which is converting into 2.3 million records and then loading to hash file. This job is taking around 55 minutes to load. If I replace hash file with sequentia...

My question is about how do I parallelize these job with multiple invocation id's by using job control routine or some other way.

Thanks
Sai

Hi

How do we call paralelly for several times (say 100 times), a job with different invocation ids?

As our underlined job, is loading huge volume of data in each instance.

Thanks
Sai

Hi We were having multiple huge sized input files, that needs to be loaded to a single table. We designed a job, which gets data from a file and load it to table. SEQFILE -> TFM -> Oracle SQL Loader Stage We enabled multiple instance to this job. Currently we would like to run multiple instances of ...

Read/Write cache size is 128 MB for both 'A' system and 'B' system.

Earlier A and B both dont have in-process row buffer or inter-process row buffer.

To improve the system I enabled B system's in-process row buffering for 128 KB.

Thanks
Sai

Hi Ray

In both the places it is as follows

64BIT_FILES 0

Oracle client is installed on both of the machines.
added tnsentries of the server and connected to DB same way using the same plugins.

Infact we just made an export copy and then imported back to the B server from A server.

Thanks
Sai

A system's top command output as follows top - 23:34:59 up 54 days, 4:29, 2 users, load average: 0.00, 0.00, 0.00 Tasks: 123 total, 1 running, 122 sleeping, 0 stopped, 0 zombie Cpu(s): 0.0% us, 0.0% sy, 0.0% ni, 99.9% id, 0.0% wa, 0.0% hi, 0.1% si Mem: 8166112k total, 8137588k used, 28524k free, 50...