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

How do you handle decimal places while importing a flatfile
into informatica?

Answer Posted / maruthi

1.)use to_integer('column name','newcolumn)
it works

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Design a mapping to load the cumulative sum of salaries of employees into target table?

1500


What are the tasks that can be performed using sq?

1089


where to store informatica rejected data? How to extract the informatica rejected data?

999


What is mapping debugger?

1010


What are roles and groups and benefits of using them?

1055


How to use pmcmd utility command?

1026


What is aggregate cache in aggregator transformation?

1139


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2146


How would you join a node to the already existing domain?

1124


Briefly define reusable transformation?

1126


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1121


Explain what is informatica metadata and where is it stored?

1047


Explian the Process of deployment groups in informatica

1059


What is a sorter transformation?

1101


What is option by which we can run all the sessions in a batch simultaneously?

1137