Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by alexle

  1. alexle

    denormalize

    This is the exact information I'm looking for. However, can you help me to get an idea how to do it in Informatica ETL Mapping? You were referring to Expression and Aggregator. thank you.
  2. alexle

    Swapping Rows and Columns

    Thank you for responding. I know for a fact that I need 5 columns. However, the present datasource doesn't lay out neatly for me to insert the rows into the columns. In other words, the current datasource is in the tree format. Would the normalizer expression help?
  3. alexle

    Swapping Rows and Columns

    Is there any trick for swapping rows and columns of a XLS datasource in Informatica? In other words, I have an XLS files that are row format and would like to turn those rows into Column Format using Informatica. Original Format # ProgID Desc ParentID 1 1000 TopLevel...
  4. alexle

    Reset CUME() value when new encounter new key

    Thank you MacLeod72...Your solution worked great. Thank you so much...
  5. alexle

    Reset CUME() value when new encounter new key

    Thank you for responding. do these ports have to be in the exact sequential order as you described?
  6. alexle

    Reset CUME() value when new encounter new key

    I'm using CUME() function in my expression to do calculate a running-total. However, the CUME function doesn't reset the value when a new key (program name in my case) is encountered. The CUME() sums all the rows from top to bottom as one single category. I would like to know if there is a...
See more

Part and Inventory Search

Back
Top