Search found 51 matches

by trenicar
Tue Apr 07, 2015 4:44 am
Forum:
Topic: Will Metadata workbench show Transformation rule (DS 9.1)
Replies: 4
Views: 4653

OK thanks

I have found it , it was avail when I hovered over the transform, I kept missing it, and then later when you drill fully to the field level
by trenicar
Wed Apr 01, 2015 9:14 am
Forum:
Topic: Will Metadata workbench show Transformation rule (DS 9.1)
Replies: 4
Views: 4653

Hi

Does this still work for version 11.3.1?
by trenicar
Wed Apr 01, 2015 2:50 am
Forum: General
Topic: Add Parameter - Script
Replies: 8
Views: 4305

This is a link to a series of perl scripts that can help
viewtopic.php?t=113429
by trenicar
Wed Apr 01, 2015 2:37 am
Forum: General
Topic: Add Parameter - Script
Replies: 8
Views: 4305

There was a script to do this written and made available , you may be able to look it up on DSxchange - see below

Script Name: ReplaceParameterBlock.pl
# Author : John Miceli
# Create Date: 10/10/2006
by trenicar
Wed Jan 28, 2015 1:44 am
Forum: General
Topic: Can we enable RCP in a Dataware Environment or not ?
Replies: 10
Views: 9125

We have subsequently found that there is a IGC Rollup patch no 6 that fixes this problem, maybe not perfectly, but better
by trenicar
Mon Jan 26, 2015 7:52 am
Forum: General
Topic: Can we enable RCP in a Dataware Environment or not ?
Replies: 10
Views: 9125

eostic wrote:Unless you are using 11.3, where rcp is fully sipported in lineage.
We are using 11.3.1 and i have tested this but cannot see the columns being populated? Can you explain what we can expect from this , and is there anything different we have to do
by trenicar
Wed Dec 03, 2014 5:26 am
Forum:
Topic: How to load Extended Data Mapping and Source
Replies: 8
Views: 7347

Ernie Just for clarity the issue was the lack of path as you suggested, this does not seem to be documented anywhere There are a number of conflicting sample files floating about, its difficult to know which to use Also I note that in the above example there are other attributes that are available. ...
by trenicar
Wed Dec 03, 2014 5:19 am
Forum:
Topic: How to load Extended Data Mapping and Source
Replies: 8
Views: 7347

Hi Ernie

thanks for the input

I have loaded the data source and created a mapping doc and linked them
But I dont see how to connect the Extended mapping Doc to the Application
by trenicar
Tue Dec 02, 2014 8:17 am
Forum:
Topic: How to load Extended Data Mapping and Source
Replies: 8
Views: 7347

this is the message i get when trying to load file

The extended data source type DataFile,DataFileStructure,DataFileField in line 1 is not valid.
by trenicar
Tue Dec 02, 2014 7:35 am
Forum:
Topic: How to load Extended Data Mapping and Source
Replies: 8
Views: 7347

How to load Extended Data Mapping and Source

We are using Infosphere 11.3.1 (with Oracle Metadata repository) I am trying to create External Mapping Documents for the following process I have an application which receives a file and moves it to a Hadoop filesystem, in a particular directory. This file is then picked up by a datastage job . Wha...
by trenicar
Mon Nov 24, 2014 4:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read a binary EBCDIC file that is on Hadoop
Replies: 1
Views: 2677

How to read a binary EBCDIC file that is on Hadoop

Hi I have various binary EBCDIC files which I need to read from Hadoop. I have read the files via a CFF stage (EBCDIC) when I have just the files. How can I read from Hadoop? Do I need to land the files somewhere and then use the CFF stage? The problem is they are very large files 100's GB Or is the...
by trenicar
Tue Nov 18, 2014 1:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is Orchestrate record schema structure the best to use
Replies: 3
Views: 3603

Thanks Ray The problem I have is that the files are flat files and if i imported them I would need to define each field, However I have access to an Oracle Designer repository, where these files have been defined, unfortunately I dont have access to the actual tables. Similarly I probably can access...
by trenicar
Mon Nov 17, 2014 7:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Is Orchestrate record schema structure the best to use
Replies: 3
Views: 3603

Is Orchestrate record schema structure the best to use

I have seen a copy of the Orchestrate 7.0 Record Schema manual. Is this still relevant, within Infosphere 11.3 The reason I ask is that I have about 2000 files of various types (mainly, delimited , fixed width or Cobol ) and I would like to define a process that can be used to automate the creation ...
by trenicar
Sat Dec 07, 2013 4:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Compare input column with Loop cache value in transformer
Replies: 8
Views: 10332

Just to give a bit more background I have the following data key1 key2 date value 123 111 1/1/12 500 123 113 1/2/12 300 123 115 1/3/12 600 123 117 1/4/12 100 125 121 1/1/12 500 125 133 1/2/12 300 126 165 1/3/12 600 126 167 1/4/12 100 The data is sorted by key1 , date Key 1 is a set of records that ,...