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 to load data in informatica ?

1070


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2252


What is rank transform?

1061


WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1965


expain about the tune parameters?

2458


What is mapplet in informatica?

1129


What are the different versions of informatica?

1337


How big was your fact table

1864


How do you load only null records into target?

1254


What is meant by a domain?

1189


whats the logic to load the lower level of granularity of data to fact table.

2311


difference between informatica 8.1.1 and 8.6

3732


What is the status code in stored procedure transformation?

1234


How do you migrate data from one environment to another?

1149


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

2392