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
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 |
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 |
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.
What is complex mapping?
What is up date strategy and what are the options for update strategy?
What is partioning?how many types of partinings are there
What is the use of an aggregator cache file?
What is Micro Strategy? Why is it used for?
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
What is best approach to load 100 different source files (Different structure) to differet target tables ?
Quickly characterize reusable change?
when informatica 8 series released ?
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?
Explain the informatica workflow?