Search found 103 matches
- Thu May 03, 2012 6:20 am
- Forum: General
- Topic: Processing list of files in a Sequence job
- Replies: 5
- Views: 3568
- Wed May 02, 2012 8:45 pm
- Forum: General
- Topic: Processing list of files in a Sequence job
- Replies: 5
- Views: 3568
Processing list of files in a Sequence job
Hello, I have to process a list of files in a loop in the sequence and I am running into an issue. First I get the list of files by doing a ls -m(Execute Command Activity) and then use the start loop activity to process the files thorugh the sequence of jobs one after the other. The issue is the las...
- Wed May 02, 2012 8:22 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata SQL Assistant - Does not display intl characters
- Replies: 4
- Views: 5510
- Mon Apr 30, 2012 8:28 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Teradata SQL Assistant - Does not display intl characters
- Replies: 4
- Views: 5510
Teradata SQL Assistant - Does not display intl characters
Hello, I have loaded a file with international characters from around the world in UTF-8 format using DataStage 8.0 parallel job into a Teradata Unicode table. When I export the table from BTEQ and open the file in Excel(Using UTF-8), I am able to display all the international characters. If I run a...
- Mon May 30, 2011 2:03 am
- Forum:
- Topic: Importing a physical data model into the Metadata Workbench
- Replies: 3
- Views: 2798
I imported the cobol copybook into IDA and it created a Logical model. I then created a physcial data model from the IDA and then used the DBM metabroker from the Import/Export Manager. I am now able to able to see the database names and schemas( I had not applied the filters correctly when exportin...
- Wed May 25, 2011 3:25 am
- Forum:
- Topic: Importing a physical data model into the Metadata Workbench
- Replies: 3
- Views: 2798
Importing a physical data model into the Metadata Workbench
Hello, I imported a cobol copybook into the Infosphere Data Architect and created a physical data model out of it. Now I imported this model into the metadata repository using Import/Export manager and it finished successfully without any errors. Now I am unable to find the model in the metadata wor...
- Tue Nov 09, 2010 4:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: A remote host refused an attempted connect operation
- Replies: 0
- Views: 2968
A remote host refused an attempted connect operation
Hello, I get the following error when doing a check on my apt_config_file. We did a new installation and nodes are defined on the ETL as well as DB2 boxes. I am able to ssh to the different boxes from the server but when I try to test the config file I get the following error. ##I IIS-DSEE-TFCN-0000...
- Tue Aug 31, 2010 3:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Lookup size 3373708168 bytes
- Replies: 2
- Views: 2436
Re: Lookup size 3373708168 bytes
Hi I design a job to find out missing data. But i have find out Reject data that is why i am using Lookupstage. If you are using the Lookup stage just because you have to capture the reject rows, then you can do a left join in a Join stage and filter out the reject records in a transformer or Merge...
- Tue Aug 10, 2010 8:18 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query issue
- Replies: 2
- Views: 2094
- Tue Aug 03, 2010 1:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DECIMAL(38,10) TO INTEGER(14)
- Replies: 1
- Views: 2085
- Tue Aug 03, 2010 1:14 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Union Function
- Replies: 7
- Views: 3884
Yes. From Anbu's design.. --Define the column name(field 1) in the row generator as the same as what is defined in DB2. -- Open the properties for that column in the row generator stage. Click on Algorithm. Add values ('AAA'). Add the values again ('BBB'). -- Set the row generator to run only for 2 ...
- Tue Aug 03, 2010 1:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Datastage Path
- Replies: 8
- Views: 11587
- Tue Aug 03, 2010 8:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Reg: Reference data size for lookup stage.
- Replies: 7
- Views: 3768
- Tue Aug 03, 2010 8:30 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Unable to trim the data -loading into db2 bulk load stage
- Replies: 11
- Views: 7298
- Fri Jul 23, 2010 2:44 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: transformer logic
- Replies: 8
- Views: 4757