venu adavelly

• Sep 17th, 2007

 

|| is used to concatinate two or more columns in Informatica
for exp; firstname (venu)
last name (adavelly)
but expecting out put is venu adavelly
so we need to concatinate firstname and last name
fristname||' '||last name ( we can give any secial in b/w ' ',like | or , or @ etc )
output will be venu adavelly