How can we get two output ports in un-connect transformation?
Answers were Sorted based on User's Feedback
Answer / prabhu
You can use lookup override to concat two columns from tble
and return as single column(eg COL1||','||col2 as
COLUMN).You can pass this to expression transformation and
parse it to split it again
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 9 Yes | 0 No |
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
explain about lookup t/r?
following table source target name gender name target a1 male a1 female a2 female a2 male i want a1 female update to target how will do?
There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
why do we go for update strategy tr in SCD rather using the session properties?
How can you increase the performance in joiner transformation?
How will you update the first four rows and insert next four rows in a mapping?
what is the mechanism of the Master-Detail joining condition?
What are events in workflow manager?
how do the project develops? pls specify right from the start to end in step by steps.
What is power center repository?