Search found 60 matches
- Wed Oct 20, 2010 8:03 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: ORCH_WORK tables getting created by teradata enterprise stag
- Replies: 0
- Views: 1091
ORCH_WORK tables getting created by teradata enterprise stag
When I try to write to a teradata table, an ORCH_HOME table is created every time the job is executed and data is written to the table. Any idea on how to set it as one single table, so that DS can overwrite that table everytime the job is executed, instead of multiple tables getting created? Thanks
- Wed Oct 13, 2010 8:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Single row output from XML input stage!!
- Replies: 5
- Views: 2957
Code: Select all
Tag b --> /a/b
Tag c --> /a/c
- Wed Oct 13, 2010 8:01 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Single row output from XML input stage!!
- Replies: 5
- Views: 2957
- Wed Oct 13, 2010 7:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Single row output from XML input stage!!
- Replies: 5
- Views: 2957
Single row output from XML input stage!!
We have used XML input stage to read Xml file. Bofore XML input stage we have used external source stage to feed the XML input stage. We have loaded the the XML input stage its meta data, and made a column as 'key' column since I got a warning that a key column should be specified for a repetition e...
- Mon May 25, 2009 8:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Issue with picking the right record - sort output
- Replies: 1
- Views: 1193
Issue with picking the right record - sort output
Hi, I have the following requirement to be implemented in the job: There are 4 - 5 fields in a file, out of this there are two fields based on which the record can be treated as a duplicate. For example, Scenario 1: F1,F2,F3,F4,F5 100,200,300,Y,- 100,200,300,Y,99 100,200,300,N,81 100,200,300,Y,81. I...
- Thu Apr 30, 2009 1:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup on oracle table having dates,sparse lookup not workin
- Replies: 4
- Views: 2077
Re: Lookup on oracle table having dates,sparse lookup not wo
So, You can Resolve the issue. I have a new issue here. Since I gave multiple rows return option in the lookup, for a source record if there are more than one matching record in the lookup, then the output of the lookup is 2 identical rows(all columns from source) except for the other column fetche...
- Tue Apr 21, 2009 7:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup on oracle table having dates,sparse lookup not workin
- Replies: 4
- Views: 2077
Re: Lookup on oracle table having dates,sparse lookup not wo
Thanks a lot, I tried the 2 option without sparse lookup and it worked. Hi, 1) your date comparision is incorrect. You are comparing strings here instead of dates. ( I assume that incoming date value is a string ) to_date(ORCHESTRATE.STDATE,'yyyymmdd') between RECEFFDATE AND decode(RECENDDATE,'',sys...
- Tue Apr 21, 2009 1:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup on oracle table having dates,sparse lookup not workin
- Replies: 4
- Views: 2077
Lookup on oracle table having dates,sparse lookup not workin
Hi, I have an oracle table with an customer id, customer name, start date,end date. This is a dimension table with SCD-Type2 logic. I have a source txt file which has a date column and the customer id. I need to fetch the customer name from the dimension table(oracle) based on the customer id and th...
- Fri Nov 14, 2008 6:37 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reading a fixed widtjh file
- Replies: 3
- Views: 1770
Reading a fixed widtjh file
I am trying to read from a fixed width file, The file has fixed length record with 500 fields. I am reading only 50 fields out of it by giving the appropriate start positions. The record length is 3300 characters. I'm reading all fields as Char. When i execute the job, it gives me the following warn...
- Tue Aug 05, 2008 12:09 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenation of 4 fixed width files into one file
- Replies: 2
- Views: 1488
Concatenation of 4 fixed width files into one file
Hi, We have a job which reads a record from a source file(csv), splits that single record into 4 records. These four records are populated to four different fixed width files. Each record has a different metadata. that is the number of columns vary between the 4 records, whereas the record length is...
- Fri Dec 15, 2006 7:50 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NLS values.
- Replies: 6
- Views: 2346
- Thu Dec 14, 2006 3:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NLS values.
- Replies: 6
- Views: 2346
- Thu Dec 14, 2006 12:16 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: NLS values.
- Replies: 6
- Views: 2346
Hi I have set UTF-8 as the default NLS value for a project in DS Administrator. I imported and recompiled the jobs that were devloped without NLS,to this project.But the NLS values in the different stages of the job do not reflect the Project Default(UTF-8). Any inputs on this is highly appreciated....
- Thu Dec 14, 2006 12:08 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML file with multiple repetitive columns
- Replies: 6
- Views: 3725
- Tue Dec 12, 2006 10:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: XML file with multiple repetitive columns
- Replies: 6
- Views: 3725