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



Group memberships:
Premium Members

Joined: 01 Aug 2010
Posts: 232
Location: Pune
Points: 2274

Post Posted: Mon Aug 02, 2010 4:53 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi,

Did anyone performed Profiling on Mainframe file with Multiple record type?
Is thereanyway can we do profiling on Maniframe file without ETL Job?
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54621
Location: Sydney, Australia
Points: 296179

Post Posted: Mon Aug 02, 2010 5:41 pm Reply with quote    Back to top    

No. You need to profile each record type separately. If there are fields that are common to different record types and you want to profile all of those, you need to assemble them into a single place ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
synsog



Group memberships:
Premium Members

Joined: 01 Aug 2010
Posts: 232
Location: Pune
Points: 2274

Post Posted: Mon Aug 02, 2010 9:16 pm Reply with quote    Back to top    

ray.wurlod wrote:
No. You need to profile each record type separately. If there are fields that are common to different record types and you want to profile all of those, you need to assemble them into a single place, such as a temporary table.


Thanks Ray for quick Reply!!
Let say if i Maintain the reationship between record type and do profiling after writing Datastage Job though ETL by Converting Mainframe Dataset to Text file. Is there any way i can do this on RUn time by Scheduling a ETL and IA job in Batch process without any Issue.
I want to kow whether it is possible to run my jobs after doing Profiling on Source FIle.

I am looking for Below thing.

Source (Mainframe)----> ETL job to Convert in Text----> Do profile---> then Proceed with ETL trnaformation.
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54621
Location: Sydney, Australia
Points: 296179

Post Posted: Mon Aug 02, 2010 11:38 pm Reply with quote    Back to top    

Not really without a lot of reconfiguration or tricky synchronization. Profiling takes place in a dedicated project called ANALYZERPROJECT by default, while a different project is used for ETL. ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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