DSXchange

Hi Gurus, We have a requirement to verify if the data string from the master data set includes the string from the lookup reference dataset. e.g. If the source data element is 'Made in USA' and the reference data is a list of countries and includes 'USA', it should be a match. Master Data : Made in ...

This is opening up an old thread but since the topic is related, didn't want to start a new one 8) With reference to the "Rules Dispatcher" approach, essentially the "Rule" still needs to be predefined in one of the routines in which case any new logical rule will still require a...

Thanks Ray, for your help

Hi,

I am trying to use "Multiload" in "TeraDataConnector PX". I am unable to find that option under that stage.

Can somebody help me find the steps to do a "Multiload" in "TeraDataConnector PX".

Appreciate everyone's help

Thanks !!!! Appreciate your help.....

Thanks Craig for your reply..The function is "TimeStamptoDate" and "TimeStamptoTime" function....Is that the best option then using "Field"...

Hi, I have a requirement where I need to Extract the "Date" and "Time" Value from timestamps column.. Column "C" is Defined DataType as TimeStamp and has value as "2013-09-21 21:22:22" I need to get Date in Column "A" (DataType = Date) and Time in Co...

Error says :

User is not authorised to perform the opration

CommonMetadata.commonmetadataimportroles

Which role is reuired to do the same ?

Hi,

My source files are mainframe files.

We have used CFF stage to convert them into ASCII format and load the data in Target tables.

i want to show case data lineage from Mainframe files to database table.

Can Mainframe files placed on Unix box be included in Data lineage ?

It says :

An error occured when creating the data file in the repository representing the pathname

Hi,

I have imported a sequential file into Datastage using sequential file table creation.

I want this table definiton to used in Metadata workbench so i am making this as shared table .

I am getting the error as error occured while creating data file in the repository.

Any help is appreciated

Hi All,

I have requirement to show case impact analysis for my data Integration project.

After the jobs are completed and target tables are populated we have DB2 stored procedures using this data.

How can i import the stored procudures used in DB2 to show case impact analysis in Meta Data workbech?

Thanks Got it

Hi All,

I want to show the business lineage in Metadata workbench from my Source which is text file placed at Unix box to the Staging table and then to Target Database.

Please help me to include the text file in my Business lineage.

Thanks in advance

Hi All,

Can anyone help me with this