Answer Posted / jvdwhinfo
Hi guys,
Here all the above answers are absolutely correct.
i.e we can use both concatenate operators as well as pipe
operators.We gonna get the desired output.
But only difference is the performance.We'll get better
performance by using pipe (||) operator rather than
concatenate.
Please let me know if you want to give further suggestions.
Thanks.
James
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain about cumulative Sum or moving sum?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Is it possible to use a client with different version than that of its Informatica server?
Briefly define a session task?
Write the unconnected lookup syntax?
What is a node in Informatica?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
differences between service based and product based?
Is it possible to create multiple domains on a single Informatica server?
What is incremental aggregation?
How you prepared reports for OLAP?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How do you set a varible in incremental aggregation
How identifying bottlenecks in various components of informatica and resolving them?
What is standalone command task?