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

I have a source as flat file and having data like
""TCS"MUMBAI" and i want output like TCS MUMBAI,the length
of the data in the rows is variable.how can you fix it?

Answer Posted / chanakya123

Dear Chow,thanks for ur reply, the SQ reading "" only from
""TCS"MUMBAI",the rest of the part truncated,then how can u
use ltrim and rtrim, i tried it creating a mapping.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

2205


What is workflow? What are the components of the workflow manager?

1060


Differentiate between router and filter transformation?

951


What do you mean by worklet?

1015


Explain constraint based loading in informatica

1034


What are the different lookup cache(s)?

1032


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1905


Define pmcmd command?

988


How you prepared reports for OLAP?

1543


Define mapping and session?

966


Write the unconnected lookup syntax?

1029


expain about the tune parameters?

2334


Difference between Target-based loading and constraint-based loading?

943


What are the types of lookup transformation?

1021


What is a grid in Informatica?

998