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

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,


What is complex mapping?

1 Answers  


What is up date strategy and what are the options for update strategy?

2 Answers  


What is partioning?how many types of partinings are there

2 Answers   HCL,


What is the use of an aggregator cache file?

1 Answers  


What is Micro Strategy? Why is it used for?

5 Answers   Infosys,


hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help

1 Answers  


What is best approach to load 100 different source files (Different structure) to differet target tables ?

2 Answers   IBM, TCS,


Quickly characterize reusable change?

1 Answers  


when informatica 8 series released ?

1 Answers   IBM,


while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,


Explain the informatica workflow?

1 Answers  


Categories