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

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

1017


How to load the data from a flat file into the target where the source flat file name changes daily?

1060


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1961


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1282


In development project what is the process to follow for an etl developer from day1

1724


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2237


Is there any way to read the ms excel datas directly into informatica?

1022


Explain sql transformation in script mode examples in informatica

1132


What do you understand by a term domain?

1125


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2356


Briefly define a session task?

1133


Why filter transformation is an active one?

987


What is the need of an ETL tool?

1094


How do you handle two sessions in Informatica

1164


can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2518