Reading data from Initiate through Clover ETL

indu

• June 27, 2011 00:00

• Answered

Follow

Hi,
Could u please help me on how to read data from Initiate through Clover ETL. I tried using Memget component, but i could'nt understand why is an input reader needed for memget component and how to configure the mapping(Key field and Input field).
What are segment code filter and segment attribute filter used for?

Hope to get a reply soon,
Advance Thanks.
Indu

• 

  avackova

  • June 27, 2011 11:19

  0

  Comment actions Permalink

  Hello Indu,
  Memget component is used to retrieve a specific member using a member key value such as an Enterprise ID (EID), or Source Code (srccode) and Member ID number (memidnum). This key is provided by input port and in mapping attribute you define mapping between Clover input field(s) and these key values in the hub. Mapping attribute also defines output mapping, that means mapping between fields from the hub and output Clover fields. Really good description (with screen-shots) of Memget component can be found in WORKBENCH USER GUIDE.
• 

  indu

  • June 28, 2011 07:24

  0

  Comment actions Permalink

  Thanks for ur reply,
  I am trying to read data from the Initiate, i have used a data reader through which i am passing the MemRecno and trying to read data from Initiate using MemRecno as the key input and mapping attribute fields to output fields and writing the output fields to a file using universal data writer.
  
  Though the graph runs successfully data is not being written into the file.
  When i checked the log file i can see the following error:
  ERROR [MEMGET_DATA_READER0] - MemGet execute error: errorCode:ENOREC ErrText: member(s) found but none remain after being filtered.
  
  Please let me know why am i getting this error and how to resolve.
  Thanks,
  Indu
• 

  avackova

  • June 28, 2011 08:02

  0

  Comment actions Permalink

  Hello Indu,
  this is message populated from IHub. According to this page you should change memStatFilter attribute.
• 

  indu

  • June 28, 2011 09:14

  0

  Comment actions Permalink

  Hi Agata,
  
  I have not specified any value in the Member status filter(Memstatfilter) field.
  I also tried setting it to the below values.
  A: Active
  O: Overlay
  M: Merged
  D: Deleted
  
  Still getting the same error.
  Is there any other thing that i am missing out. Attached is the screen shot of my graph.
  Thanks,
  Indu
• 

  avackova

  • June 28, 2011 10:50

  0

  Comment actions Permalink

  Have you tried to select members with all statuses: A,I,D,S (memStatFilter="A,I,D,S") ?
  
  I can't help you more; you need to contact guys from IBM Initiate System as this is message reported by IHub, not CloverETL.
• 

  indu

  • June 28, 2011 11:27

  0

  Comment actions Permalink

  Yes i have tried including all the values in Memstatfilter. Nothing Works!
  Anyways Thanks a lot for ur quick replies.
  Appreciate it :)

Please sign in to leave a comment.