SQL: Pivot multiple rows into a single row for a Primary Key using XML_PATH.
Sample Data:
Desired Output Format:
Desired Output Format:
-
Mapping: Create sequence numbers without using sequence generator transformation. Business Requirement: This is Informatica Powe... -
Passing Value of Mapping Variable to Workflow Variable Declare a Mapping Variable Assign it in expression, this will be used at the... -
Informatica Expression Code: Chr(10): Line Feed character Chr(13): Carriage Return character. Chr(12): Form Feed Expression Code to...
No comments:
Post a Comment