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

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers   Cap Gemini,


What is meant by pre and post session shell command?

0 Answers  


Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  


How identifying bottlenecks in various components of informatica and resolving them?

0 Answers  


Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  






My source has 100 records. I have targets say in number 5. all target tables has parent and child relationships in between themselves. Now I want to load all 100 records into all targets. How U can ensure that record inserted in parent and then loaded into child.

3 Answers   Cognizant,


Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,


how can you load data into target table without leading zeor's

4 Answers   Deloitte,


What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  


What are the ETL tools available in DWH?

6 Answers   Mphasis,


What is polling in informatica ?

1 Answers   TCS,


How to join three sources using joiner?

0 Answers  


Categories