DSXchange

Thanks Ernie,

Do you mean, we need to load these chunks into table then do the profiling?

One "column" in one "row" of xml in an rdbms could potentially contain thousands of rows and columns of actual "data" to be examined.

Hi I have been granted admin rights is admin console by administrator(selected all roles). So I should be able to access any DS Project without assigning rights in DS Administrator permissions tab. But I am unable to access projects unless I have been assigned a project in DS Admin permissions tab. ...

Hi

We have XML files as source, which we want to do profiling in IA. Is that possible?, If possible we will end up doing staging and then(it is little complex as XML files are massive)

I know we can do RDBMS, Flat Files but couldn't find the way to handle XML files. Can someone advise.

Thanks

Hi When I try to open IMAM in chrome, it gives below warning Can someone advise if any changes are required to Chrome. Permission is denied [CDIMR3000E] Your browser or browser version is not supported. See the system requirements for the version of InfoSphere Information Server that you are using T...

Hi I want to remove all job log entries created 5 days before through command prompt. I know we can use CLEAR.FILE RT_LOG<Job Number> to remove whole log entries for job, but can some one suggest how to remove only unnecessary entries. DS Director allows to do these but we are not allowed to login. ...

Thanks Ernie,

I have created Extension mapping document by mapping Columns from table and Columns from Stage.

It is still showing the same way.

I checked in Monitor lineage window where Lineage Service Status is Failed for this Job.

i am going dig into it and will see what would be the problem.

Thanks Ernie,

I have done it and see the lineage It shows the lineage from table to Job but it couldn't show us the columns in any Stages.
Table which i have created using shared table metadata(From Designer to IMAM). I bound to Stage before i run the Job.

Hi Ernie, I tried Unstructured Stage and pushed the metadata to IGC via Shared Table Creationg Wizard. all fine till here. Do i need to use same Unstructured file Stage to create Job and see the Lineage? If yes, I did it but couldn't see any columns in Unstructured Stage in Job lineage. I guess we n...

Yes.... I also faced this issue

Looks like Nobody faced this kind of issue.

Hi We have project with Operational Metadata enabled for Lineage. I followed the below steps to achieve the lineage functionality but did not work. I have imported table to IMAM Imported the same table to Designer from IMAM. Imported Metadata(from shared metadata) into Oracle Connector. Ran Job. Whe...

eostic wrote:Turn off "Generate Operational Metadata" in the DataStage/QualityStage Administrator, for that Project. It is a check box.

yes, i did this for my Project. But it still creates files in xml folder.

Hi I have environment where Operational Metadata has been enabled for Lineage Purpose. As it is creating too many xml files, there are several 100's of files queing up. So we want to turn it off completely. We turned off at Project Level, And Job level(In Information Glossary--> Administration-->Lin...

I am doing select on table and there are no joins as i am extracting from single table.

Good thing is that it is working after changing the Isolation level to Read Uncommitted instead of Read commited. I am not sure how it works. But it is doing my work.

Sorry, query(select * from table) has given memory error when i ran on SSMS first time,i ran the query again and it has given the results in SSMS in 12mins.