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

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,


disable caching in a lookup transformation?

1 Answers  


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

0 Answers   HCL,


How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  


What is DTM process?

4 Answers  






In a simple mapping when i use aggregate t/r with out any condition or group by, i am getting output as only last record in the table . can any one explain it please.........?

4 Answers  


How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  


i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500

3 Answers   TCS,


my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  


Enlist the differences between database and data warehouse.

0 Answers  


What is the status code?

1 Answers  


How does a sorter cache works?

0 Answers  


Categories