Search found 358 matches
- Sun Mar 09, 2008 9:46 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transferring Language Sensitie Data from SQL Srver to Oracle
- Replies: 10
- Views: 8083
Thanks jdmiceli and ArndW, thanks for your replies for helping me out. Here is what I have done. create table langdata (data1 nvarchar(2000)) sp_help langdata gives: data1 nvarchar no 4000 yes (n/a) (n/a) SQL_Latin1_General_CP1_CI_AS Then I did this: insert into langdata values (N'この種類のドキュメントでは、添付の保...
- Thu Mar 06, 2008 10:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transferring Language Sensitie Data from SQL Srver to Oracle
- Replies: 10
- Views: 8083
Hey Ray, Thanks for the quick answer. Although I could not read your post completely but got the point that the NLS setting for the SQL Server (or the character map) is inappropriate. But can you plz let me know what character map should I choose for the Sql server character set Latin1_General, beca...
- Thu Mar 06, 2008 9:58 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Transferring Language Sensitie Data from SQL Srver to Oracle
- Replies: 10
- Views: 8083
Transferring Language Sensitie Data from SQL Srver to Oracle
Hi All, Good to see this forum, after long long time, active and happening. Here is the description of what I am trying to accomplish. Transferring data from Sql server stored in nvarchar columns (language sensitive, Japanese and english+may be some other language) to Oracle (UTF8 character set enab...
- Thu Mar 22, 2007 12:31 am
- Forum: General
- Topic: SCD 2 Dimension Design Question
- Replies: 1
- Views: 2175
SCD 2 Dimension Design Question
Hi All, Thanks for all the help you have provided so far. Ok, this is related with SCD2 dimension and I need your experience for designing the hierarchy table associated with a SCD2 dimension. The hierarchy is a recursive hierarchy. My question is what usual practice is followed for designing recurs...
- Wed Mar 21, 2007 11:59 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DataStage Job - Error in compiling job at transformer stage
- Replies: 5
- Views: 5496
- Tue Mar 20, 2007 4:51 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Generating Multiple Rows from single row
- Replies: 6
- Views: 3131
- Wed Mar 14, 2007 3:32 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Variable "APT_AUTO_TRANSPORT_BLOCK_SIZE" missing
- Replies: 14
- Views: 8896
Got this from the manual: Setting Transport Block Size You can set the APT_AUTO_TRANSPORT_BLOCK_SIZE to True to have DataStage automatically calculate the block size for transferring data for transferring data internally as jobs run. The APT_DEFAULT_TRANSPORT_BLOCK_SIZE variable defines the block si...
- Wed Mar 14, 2007 3:20 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find out which user deleted a particular job?
- Replies: 7
- Views: 3595
- Wed Mar 14, 2007 3:10 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Reading parameter from a file or Table
- Replies: 7
- Views: 3873
- Wed Mar 14, 2007 2:28 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Variable "APT_AUTO_TRANSPORT_BLOCK_SIZE" missing
- Replies: 14
- Views: 8896
- Wed Mar 14, 2007 2:18 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: how to find out the difference between two similar jobs
- Replies: 4
- Views: 2267
- Wed Mar 14, 2007 2:15 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to find out which user deleted a particular job?
- Replies: 7
- Views: 3595
- Tue Mar 13, 2007 2:38 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Cascading Lookups
- Replies: 6
- Views: 3365
Looking at the topic heading Cascading lookup. I guess you mean something like Src Col1 to be Lookuped to Col1 (hash1) Col2 (hash1) to be lookuped to Col2(hash2) Cascading lookup is possible in the data stage, could be done in two ways 1st: In One transformer In TX1 Src Col1 to Hash1 Col1 and Hash C...
- Thu Jan 04, 2007 4:45 am
- Forum: General
- Topic: dynamically passing tablename
- Replies: 8
- Views: 7026
- Wed Jan 03, 2007 3:02 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Running Multiple Instances-Partition By Date
- Replies: 7
- Views: 4468