DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
Nagac



Group memberships:
Premium Members

Joined: 29 Mar 2011
Posts: 125
Location: India
Points: 1042

Post Posted: Sat Oct 08, 2016 5:22 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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.

When I see the Lineage via Job it shows the table but context is different(context shows table is on Datastage Server).

When I try to see the lineage by clicking on Physical table. it doesn't show any lineage it looks like standalone table.

Please advise if I miss any configuration

Thanks
Nagac



Group memberships:
Premium Members

Joined: 29 Mar 2011
Posts: 125
Location: India
Points: 1042

Post Posted: Wed Oct 12, 2016 6:17 am Reply with quote    Back to top    

Looks like Nobody faced this kind of issue.
Rate this response:  
Not yet rated
leandrohmvieira
Participant



Joined: 02 Sep 2015
Posts: 44
Location: Brasilia, Brazil
Points: 438

Post Posted: Thu Oct 13, 2016 11:02 am Reply with quote    Back to top    

Are tables transparent? If they look transparent, its a virtual asset, on this case you must map connection to database on IGC.
I followed this steps and was able to fix the problem:

http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.mdwb.doc/topics/t_data_connection_mapping.html

Further information about the problem here:

http://www.ibm.com/support/knowledgecenter/SSZJPZ_11.3.0/com.ibm.swg.im.iis.mdwb.doc/topics/r_assetTypesSourceReports.html

_________________
Leandro Vieira

Data Expert - Brasilia, Brazil
Rate this response:  
Not yet rated
eostic

Premium Poster



Group memberships:
Premium Members

Joined: 17 Oct 2005
Posts: 3794

Points: 30536

Post Posted: Thu Oct 13, 2016 5:25 pm Reply with quote    Back to top    

Exactly. You need a data connection mapping to reconcile the abstracted commection name to your actual hoat + database desired for lineage. Remember that you could theiretically have the same dat ...

_________________
Ernie Ostic

blogit!
Open IGC is Here!
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours