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

GeekInterview.com

I am new, Sign me up!

GeekInterview.com > Tech FAQs > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 296 of 327

Print

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: 5

Last Update: August 12, 2009 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

#1

Member Since: June 2008 Contribution: 7

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

#2

Member Since: July 2008 Contribution: 12

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

#3

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

October 13, 2008 01:04:23

#4

Member Since: October 2007 Contribution: 5

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

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

Is this answer useful? Yes | No

August 12, 2009 09:43:19

#5

Member Since: August 2009 Contribution: 1

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

emp_first_name |' '|emp_middle_name|' '|emp_last_name

Is this answer useful? Yes | No

Sponsored Links

About Us - Privacy Policy - Terms and Conditions - Contact - Ask Question - Propose Category - Site Updates

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved