Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

scenario: dept_no emp_nem 10 A, 10 B, 10 C, 10 D, 20 P, 20 Q, 20 R, 20 S
output: dept_no emp_nem 10 A, 10 AB, 10 ABC, 10 ABCD, 20 ABCDP, 20 ABCDPQ, 20 ABCDPQR, 20 ABCDPQRS

Answer Posted / kumar

Use a variable to hold "emp_nem" Like

V1=emp_nem
V2=v1
o/p V2||v1

this is will give the desired output.

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to load last n records of file into target table - informatica

1054


Performance tuning in UNIX for informatica mappings?

2549


What is expression transformation?

1086


Name the different lookup cache(s)?

1214


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2378


Explain in detail scd type 2 through mapping.

1028


Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1042


IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??

1027


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1890


Is it possible to use a client with different version than that of its Informatica server?

1122


How we can create indexes after completing the load process?

1145


How many transformations can be used in mapplets.

1909


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6148


Explain direct and indirect flat file loading (source file type) - informatica

1305


Difference between Data and Index Caches?

1126