How three column in one table concatenated in Informatica?

How three column in one table concatenated in Informatica?When i am giving SAL || COMM || DEPTNO in exp it's failed to read during testing.By giving (CONCAT(CONCAT(SAL,COMM),DEPTNO)) i am also getting error during testing.

dkm111
Profile Answers by dkm111 Questions by dkm111
May 29th, 2008
5
13762

Questions by dkm111

Informatica

Answer

Showing Answers 1 - 5 of 5 Answers

adilshariff
Profile Answers by adilshariff

Jun 30th, 2008

Remove the last paranthesis and then try.the parsing will be successful.
(CONCAT(CONCAT(SAL,COMM),DEPTNO)

Mamta11
Profile Answers by Mamta11

Jul 26th, 2008

All three columns you are concatenating should be of the same datatype. Check that.

sakthi.jaganathan
Profile Answers by sakthi.jaganathan

Aug 25th, 2008

First thing you want to note is all three datatypes should be same, then concat (sal,comm,deptno). It will work i am sure in this, because i tried it.

raj_infadev
Profile Answers by raj_infadev

Oct 13th, 2008

In Informatica its better to use the symbols to make the operation faster cause Power Center Server can understand the symbols more easily than the function names....

For Example: Concatenation operation can be done like this....

Create 2 variable ports V1 & V2

V1 ---> SAL || COMM
V2 ---> V1 || DEPTNO

Output Port ---> V2....

Hope you understood or else let me know to make it clear.....

Regards
Raj