Answer / saradhi

by using concatination operator u can get it.
firstname||lastname

Answer / giri

Very Simple Use Expression transformation add condition Concat(firstname+lastname)

Answer / ramesh.b

Use Expression transformation write condition Concat(firstname,lastname)

Answer / 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

Answer / abinitiofreak

we have to use firstname||lastname expression

Answer / venkateshmalneni

let the source is like this
first name last name
venkatesh malneni
rajesh tumalla
siva kalle

use an expression t/r create an output port with condition first name||last name
CONNECT THE OUTPUT TO THE TARGET

Answer / sarvesh

it is very simple by using expression trans

Answer / tejeya

Find the space by using the Instr() function and then split
into two.. then merge.

how much memory (size) occupied by a session at runtime

4 Answers   Wipro,

Hi, Can you please send me the Informatica 8 certification exam dumps to my email id rwork.san@gmail.com Thanks, Revathi.

6 Answers   CTS,

Define enterprise data warehousing?

0 Answers  

i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task

14 Answers   Altisource, TCS,

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

Briefly define a session task?

0 Answers  

I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?

1 Answers   Franklin Templeton,

what is the method of error handling when session is running?

1 Answers   TCS,

can you avoid static cache in the lookup transformation? I mean can you

1 Answers  

Tell me one complex query in oracle ?

2 Answers   L&T, Satyam,

what is data driven?

5 Answers   TCS, Wipro,

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

0 Answers