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


a flat file having 1 laks records. if i want convert excel
file what happen. (bcz a exccel sheet having 65536 colums
but flat files one lak columns). how to get one laks colums
in excel sheet .

Answers were Sorted based on User's Feedback



a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet ha..

Answer / urs

If you want Flat file to Excel format, convert it into excel
format and save it as .CSV(comma separate value) format.It
is having capacity 10lakhs records..

Is This Answer Correct ?    7 Yes 0 No

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet ha..

Answer / pavan_615

you can save it as CSV file .. or u have to upgrade you
office to 2007

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Informatica Interview Questions

what is datamart

4 Answers   IBM, Informatica,


As union transformation gives UNION ALL output, how you will get the UNION output?

0 Answers   Informatica,


in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,


How the facts will be loaded? explain

2 Answers   HCL,


What is InformaticaPowerCenter?

0 Answers   Informatica,


What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,


Explain what transformation and how many are there in informatica?

0 Answers  


i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.

3 Answers   Wipro,


I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers  


my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,


can we import source table without using source qualifier? if yes then how? if no then why?

2 Answers   Thomson Reuters,


Categories