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...

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104
MY REQUIRMENT IS
NAME ID
VENKATESH 101
RAJESH 102
SIVA 103
SWATHI 104

PLEASE PROVIDE ME THE SOLUTION

Answer Posted / saket

Separate VENKATESH ,101
Rajesh,102
Siva ,103 by using "||" as delimiter .


Then in the expression Divide the string Venkatesh ,101 intto two separate variable using string operation and output that two separate columns of the target

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can we update a record in the target table without using update strategy?

1087


Can we create a Integration service without a Repository service and vice versa?

1172


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

1261


As union transformation gives UNION ALL output, how you will get the UNION output?

1039


update strategy transformation in informatica

1014


Design time, run time. If you don't create parameter what will happen

1795


What are the features of complex mapping?

1096


How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1064


tell me 5 session failure in real time how can you solve that in your project?

2183


How might one distinguish in the case of mapping is right or not without associating session?

1025


Have you worked with/created Parameter file

1611


Can we create two repositories on same database instance in oracle?

1014


explain abt ur project architecture?

2122


State the differences between sql override and lookup override?

1112


Mention some types of transformation?

991