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
Differentiate between joiner and lookup transformation?
What is an expression transformation in informatica?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is the sql query overwrite in source qualifier in informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to start a workflow using pmcmd command?
How to load the data from people soft hrm to people soft erm using informatica?
What is a predefined event?
tell me the rules and responsblites in our project(my project is development)
What is the advantage of informatica?
what is the Default Source Option For Update Strategy Transformation?
can anyone explain me about retail domain project in informatica?
How many input parameters can exist in an unconnected lookup?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain what are the different versions of informatica?
