How can we get two output ports in un-connect transformation?
Answer Posted / 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 |
Post New Answer View All Answers
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is depict expression change?
Explain what are the different types of transformation available in informatica.
Differentiate between a repository server and a powerhouse?
How identifying bottlenecks in various components of informatica and resolving them?
What is deployment group?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is decode in informatica?
What is joiner transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Briefly define reusable transformation?
Why filter transformation is an active one?
What do you mean incremental aggregation?
What is the use of code page?