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
What is complex mapping?
What are the components of Informatica? And what is the purpose of each?
What is the use of an aggregator cache file?
Explain target update override in informatica
Explain what are the different versions of informatica?
What are the main issues while working with flat files as source and as targets ?
What are the modules in Power Center
What are the differences between oltp and olap?
What is sorter transformation?
Under which circumstances, informatica server creates reject files?
How to extract sap data using informatica?
where to store informatica rejected data?
What are the static cache and dynamic cache in informatica?
Can we override a native sql query within informatica?
Explain what is informatica metadata and where is it stored?