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

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,


Define enterprise data warehousing?

0 Answers  


What all are steps in up gradation of Informatica server?

0 Answers  


What is power center repository?

1 Answers  


What is sequence generator transformation in informatica?

0 Answers  






What is the functionality of update strategy?

2 Answers  


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  


Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,


How do you remove duplicate records in informatica?

1 Answers  


8.what is mapplet ?give example?

2 Answers  


What is the use of an aggregator cache file?

0 Answers  


What is a node in Informatica?

0 Answers  


Categories