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 .
- 2 Answers
- 5780 Views
- TCS, I also Faced
- E-Mail Answers
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 |
In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar
How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?
version controlling in informatica?
I have Employee table, 10 cols are connected to next transformation, only 4 cols are selected in SQL override. What would be passed to next col.
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
how can u tune u r informatica mapppings
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
What is a code page in Informatica
3 Answers American Express, Cognizant, Deloitte,
explan ur project architecture?
if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs
What are mapplets?
Teradata 
