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 .

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

765


How do you change a non-reusable transformation to reusable transformation?

690


What is deployment group?

774


Mention few power centre client applications with their basic purpose?

619


Different qualification between a related rotate toward the sky and isolates look upward?

646






How can you increase the performance in joiner transformation?

806


What is the difference between Active and Passive transformation?

736


What is the function of look up transformation?

761


What are the restrictions of union transformation?

672


How many numbers of sessions can one group in batches?

697


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1314


Explain the different lookup methods used in informatica?

686


Explain what are the different types of transformation available in informatica.

664


What will be the approach?

667


What is standalone command task?

816