Search found 3 matches

by additiya
Wed Oct 03, 2012 7:19 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding Ontology File
Replies: 6
Views: 3981

Hi chulett, Values are repeating. Like value of Xref column is 0,0, 1:a, 2:b, 3:c, 3:c,3:c,3:c But in the file we have only 3 values for xref column. 1:a,2:b and 3:c for a particular ID. For few records, for few ID we dont have any Xref column but in output I am getting the value of xref column. ple...
by additiya
Wed Oct 03, 2012 4:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding Ontology File
Replies: 6
Views: 3981

Thank you chulett for your reply. As per your suggestion i developed one server job. but it is not giving me the desired result. Job design is given below: Source file -> transformer1 -> transformer2 -> hash file ! Lookup hash file In my file ID is unique so I used id as key, then i did lookup. Extr...
by additiya
Mon Oct 01, 2012 5:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding Ontology File
Replies: 6
Views: 3981

Regarding Ontology File

Please explain how to load .obo extention file I have an obo extension file. File structure is given below: [Term] Id : 123 : abc name: abcd xref : 1:a xref : 2:b xref : 3.c alt_id: a : c alt_id: a : c is_a : 456 but i need the data in below structure: id name xref alt_id is_a 123:abc 1:a,2:b,3:c a...