Search found 126 matches

by Oritech
Wed Sep 16, 2015 8:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reading .xml file In DataStage
Replies: 4
Views: 5560

Reading .xml file In DataStage

How can we read the .xml file in Datastage? When we open .xml file in Notepad++ ,see below data (putting sample of it) Line1 - <Proponix> <Header> <DestinationID>ABC</DestinationID> <SenderID>PRO</SenderID> <OperationOrganizationID>LANZ3073</OperationOrganizationID> <MessageType>PRFADAT</MessageType...
by Oritech
Fri Sep 11, 2015 12:26 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Data Profiling of Teradata Tables
Replies: 1
Views: 4417

Data Profiling of Teradata Tables

Currently we are moving the data from Teradata to Oracle to profile them through Info Sphere 9.1 .

Can we profile the data residing into Teradata database tables directly & how?
by Oritech
Wed Jun 03, 2015 11:14 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Conversion - Varchar To Decimal
Replies: 2
Views: 3776

Conversion - Varchar To Decimal

I am trying to convert in transformer

Varchar To Decimal 38 , 10

Incoming value is DU 2015F21

Tried StringToDecimal(Ln_name.Input) function

Its converting incoming value DU 2015F21 to 0

Pls advice .
by Oritech
Tue Sep 02, 2014 12:33 am
Forum:
Topic: Importing excel in Business Glossary
Replies: 6
Views: 4727

But when its being imported it is sitting under Terms & categories.Which I dont want.

How to make them sit under Business Intelligence (best is BI Reports ) as each row in spread contains report name,description etc
by Oritech
Mon Sep 01, 2014 10:38 pm
Forum:
Topic: Importing excel in Business Glossary
Replies: 6
Views: 4727

Importing excel in Business Glossary

How can we import excel info into Business glossary?
by Oritech
Tue Jul 22, 2014 11:57 pm
Forum: Data Quality Best Practices
Topic: CreateBI ReportName&ItsAttributesUnderBG"BI Report&
Replies: 2
Views: 17351

CreateBI ReportName&ItsAttributesUnderBG"BI Report&

We need to create repository of BI Reports ie name & its attributes under BI Reports of Business glossary . How can we do this? As when I go to Create in Development Glossary,just see the options Create Term Create Categories Create rule create policy is not there should be equivent Create BI Re...
by Oritech
Wed May 07, 2014 11:21 pm
Forum: General
Topic: IIS Information Management Service Catalogue
Replies: 1
Views: 1969

IIS Information Management Service Catalogue

I need to prepare Information Management Service catalogue offered by IIS .

Shall appreciate if folks can share some tips / good materials in terms of links etc to get started.
by Oritech
Thu Mar 06, 2014 4:52 pm
Forum: Information Analyzer (formerly ProfileStage)
Topic: Automating IA Data rules run & exporting the results
Replies: 2
Views: 5422

Automating IA Data rules run & exporting the results

Currently we are manually running the data rules & exporting the results in spreadsheets.

How can we automate this process .
by Oritech
Wed Jan 16, 2013 7:03 pm
Forum: General
Topic: Integration of Infosphere with MicrosoftSharePoint
Replies: 0
Views: 1929

Integration of Infosphere with MicrosoftSharePoint

At current site, business is using lot of systems based on Microsoft SharePoint. I am after best possible way of integrating them with InfoSphere to fetch the data & also doing metadata lineage. In this relation, I came across below at IBM Site http://www-01.ibm.com/software/data/content-managem...
by Oritech
Wed Jun 13, 2012 12:55 am
Forum: General
Topic: How to re-run entire sequence?
Replies: 1
Views: 2259

How to re-run entire sequence?

I have a sequence calling child sequences & jobs. When I re-run today, some of jobs running some are not. I want to run entire sequence with all the jobs running, wondering what are to be looked into & required to be done? Vaguely thinking compiling all off them will make them re-run while s...
by Oritech
Sun Jul 10, 2011 10:28 pm
Forum:
Topic: Difference Bwt Business Glossary & Business Glossary Any
Replies: 1
Views: 1025

Difference Bwt Business Glossary & Business Glossary Any

Now days I am coming across IBM - Business Glossary and sometimes Business Glossary Anywhere.


Would like to know, are both the same or different if so what are they?
by Oritech
Tue May 31, 2011 8:59 pm
Forum:
Topic: Importing tables from Sql server database
Replies: 0
Views: 1365

Importing tables from Sql server database

Hi All, I am able to connect to sql server db via Import Export Manager & can see number of tables & columns in Import Export Manager ,but while importing, I am comin across below error,not able to see anything in metadatawork bench Opened the temporary hub file 'C:\DOCUME~1\temp\LOCALS~1\Te...
by Oritech
Fri May 27, 2011 1:44 am
Forum:
Topic: Fetching Meta data without setting connectivity at Server
Replies: 1
Views: 1322

Fetching Meta data without setting connectivity at Server

Using latest version of IBM IS infosphere 8.5, In this version, I ve been told we can fetch metadata from different sources (like Oracle,sql server etc) directly from client possibly using IBM Import Export Manager or something without setting connectivity at server level via .odbc.ini & uvodbc....
by Oritech
Thu May 26, 2011 6:45 pm
Forum:
Topic: Connectivity to Business Objects/Universe
Replies: 2
Views: 2027

Connectivity to Business Objects/Universe

How we can establish connectivity between Metadataworkbech / fast track/ Information Analyser to Business Objects/universe?

Already searched the forum.
by Oritech
Wed May 25, 2011 1:36 am
Forum:
Topic: How To Import Sql server (DTS) packagesIntoMetadataWorkbench
Replies: 1
Views: 1033

How To Import Sql server (DTS) packagesIntoMetadataWorkbench

Is there any way to import the Data Transformation Services (DTS) SQL Server packages into IBM Metadata Workbench?

Shall appreciate if folk can share there views & experiences.