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 |
what is datamart
As union transformation gives UNION ALL output, how you will get the UNION output?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
How the facts will be loaded? explain
What is InformaticaPowerCenter?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details
8 Answers L&T, TCS, UnitedHealth Group, Wipro,
Explain what transformation and how many are there in informatica?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
can we import source table without using source qualifier? if yes then how? if no then why?