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

Explain the different dimensions.

972


How identifying bottlenecks in various components of informatica and resolving them?

1137


Describe an informatica powercenter?

1130


What's the layout of parameter file (what does a parameter file contain?)?

2389


Under what conditions selecting sorted input in aggregator will still not boost session performance?

1082


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1113


What does command task mean?

1156


Can informatica load heterogeneous targets from heterogeneous sources?

1188


Enterprise data warehouse your projects phase by phase explain?

1930


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2727


Write the different tools in the workflow manager?

1071


What are the transformations that are not supported in mapplet?

1034


How are the sources and targets definitions imported in informatica designer?

1111


what is diff b/t sorter t/r and agg have the option sorter property...

2183


Why do you use Mapping Parameter and mapping variable?

1772