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

source is a flat file

empname, empno, sal
ram, 101, 1,000
sam, 102, 2,000

ques: my target needs the data to be loaded as sal -1000 and
2000 excluding commas

target

empname, empno, sal
ram, 101, 1000
sam, 102, 2000

how to implement this?

Answer Posted / hardik

We can simple concatenate 3rd and 4th Row i.e 1 and 000 and
put that concatenated output port in target.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2065


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

1052


Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?

2058


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2281


Explain sessions and how many types of sessions are there?

957


Briefly describe lookup transformation?

982


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

1841


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2102


How to go to the older version for a mapping?

1031


What is a surrogate key?

1020


How can repository reports be accessed without sql or other transformations?

1161


How to load the data from people soft hrm to people soft erm using informatica?

953


what is the size of your data warehousing?

2044


What is a joiner transformation and why it is an active one?

1001


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4678