Informatica - How three column in one table concatenated in Informatica?

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 296 of 302

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.

Total Answers and Comments: 3

Last Update: August 25, 2008 Asked by: dkm111

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 30, 2008 02:46:05

adilshariff

Member Since: June 2008 Contribution: 6

RE: How three column in one table concatenated in Informatica?

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

Is this answer useful? Yes | No

July 26, 2008 17:31:42

Mamta11

Member Since: July 2008 Contribution: 6

RE: How three column in one table concatenated in Informatica?

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

Is this answer useful? Yes | No

August 25, 2008 05:13:07

sakthi.jaganathan

Member Since: August 2008 Contribution: 8

RE: How three column in one table concatenated in Informatica?

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.

Is this answer useful? Yes | No

Go To Top