Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    Multiple Rows To Single Row in Informatica: Summary: Full Article

    Uploaded by

    Sravya Reddy
    Multiple rows of product description data from different cultures can be aggregated into a single row with multiple columns by joining the tables on a common description ID, grouping by product ID, and using an aggregator transformation with conditional logic to populate the description values into separate columns based on the culture ID.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd

    Multiple Rows To Single Row in Informatica: Summary: Full Article

    Uploaded by

    Sravya Reddy
    15 views1 page
    Multiple rows of product description data from different cultures can be aggregated into a single row with multiple columns by joining the tables on a common description ID, grouping by product ID, and using an aggregator transformation with conditional logic to populate the description values into separate columns based on the culture ID.

    Original Description:

    n

    Original Title

    Multiplerow Single

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Multiple rows of product description data from different cultures can be aggregated into a single row with multiple columns by joining the tables on a common description ID, grouping by product ID, and using an aggregator transformation with conditional logic to populate the description values into separate columns based on the culture ID.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    15 views1 page

    Multiple Rows To Single Row in Informatica: Summary: Full Article

    Uploaded by

    Sravya Reddy
    Multiple rows of product description data from different cultures can be aggregated into a single row with multiple columns by joining the tables on a common description ID, grouping by product ID, and using an aggregator transformation with conditional logic to populate the description values into separate columns based on the culture ID.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 1

    Multiple Rows to Single Row in Informatica

    ITtoolbox as adapted from Informatica-L discussion group Summary: How can I manage multiple rows to a single row - multiple column? Full Article: Disclaimer: Contents are not reviewed for correctness and are not endorsed or recommended by ITtoolbox or any vendor. Popular Q&A contents include summarized information from Informatica-L discussion unless otherwise noted.
    1/30/2006 By ITtoolbox Popular Q&A Team for

    Adapted from a response by HarHart on 1/27/2006 Join these two tables over descriptionID then use an Aggregator group by product ID first outputport productid then create 3 outputPorts englishdesc with max(iif(cultureid='en',description,' ')) arabicdesc with max(iif(cultureid='ar',description,' ')) frenchdesc with max(iif(cultureid='fr',description,' '))

    You might also like