How to merge First Name & Last Name?
Answers were Sorted based on User's Feedback
Answer / saradhi
by using concatination operator u can get it.
firstname||lastname
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / giri
Very Simple Use Expression transformation add condition Concat(firstname+lastname)
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ramesh.b
Use Expression transformation write condition Concat(firstname,lastname)
Is This Answer Correct ? | 5 Yes | 0 No |
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
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / abinitiofreak
we have to use firstname||lastname expression
Is This Answer Correct ? | 2 Yes | 1 No |
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
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / tejeya
Find the space by using the Instr() function and then split
into two.. then merge.
Is This Answer Correct ? | 2 Yes | 6 No |
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica
what is threshold error in informatica?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
in oracle write query yourname+1 from dual
how to create a sample mapping for dynamic lookup transformation
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
define galaxy repository in informatica
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
what is flat file override?
please let me know which type of question arise in interview on project manager round on insurance project with answer pls reply asap.