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
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 |
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
disable caching in a lookup transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
What is DTM process?
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.........?
How do you remove duplicate records in informatica? And how many ways are there to do it?
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
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
Enlist the differences between database and data warehouse.
What is the status code?
How does a sorter cache works?