IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only
Back to discussions
Expand all | Collapse all

Data not processing completely while loading one SQL DB Output Card to Second SQL DB Output Card.

  • 1.  Data not processing completely while loading one SQL DB Output Card to Second SQL DB Output Card.

    Posted Sat July 17, 2021 11:11 AM
    Need some help on finding a solution   I facing a issue with SQL server extract.

    My requirement is to read data from SQL server table dynamically based on the Input data received and load it to another SQL DB.

    Integration Pattern is SQL DB to SQL DB  ( Both are MS SQL DB's)

    I was able to take input data and Query the DB (First DB) (in my output card 1) and I am trying to pass the output received in First DB output Card  to second SQL Output card 2(Second DB) . 

    when  multiple rows returned from First Output Card , the second output card is processing only first row alone and ignoring all other rows.

    My Analysis 
    ==========
    I tried to write data from  output card 1 to a file ( i am able to see all the rows in the file)

    i tried to read the file as a input card and passed/mapped to the output Card of the second database ( it is able to parse all the Rows).

    i suspect while loading the data from 1st output card to 2nd Output Card . looks like delimiters are not being applied properly.

    Can I know how can I fix this...?

    ------------------------------
    Narendra Chimakurthi
    ------------------------------

    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  RE: Data not processing completely while loading one SQL DB Output Card to Second SQL DB Output Card.

    Posted Sat July 17, 2021 12:46 PM

    You should use the same type tree for input and output. There is no difference between generating type tree from a query like Select * from table1 or generating type tree from table.  However if you insist on using different type trees, adjust your Terminator on the row level in the type tree.

     

    Rex Chan

    World Wide tech sales for IBM Transformation Extender (ITX)

    1-626-318-7782

     

    ::DISCLAIMER::
    The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. E-mail transmission is not guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or may contain viruses in transmission. The e mail and its contents (with or without referred errors) shall therefore not attach any liability on the originator or HCL or its affiliates. Views or opinions, if any, presented in this email are solely those of the author and may not necessarily reflect the views or opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of authorized representative of HCL is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any email and/or attachments, please check them for viruses and other defects.



    Original Message