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 |
wat are deployement groups in informatica, how it will be used for developers
What is critical mapping?
What are the circumstances that infromatica server results an unreciverable session?
When the informatica server marks that a batch is failed?
Briefly describe lookup transformation?
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?
1 Answers Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
How can we store previous session logs?
. Design a mapping, first two phone calls received by a customer must be represented as "Home" , "Office" and the next calls must be concatinated and represented as "Other".Look at the below tables :: Source Definition Customer Phone_Number A 9848403211 A 9812675432 A 9112356788 A 9876503276 B 9567890765 B 9876098567 AND THE TARGET IS Customer Home Office Other A 9848403211 9812675432 9112356788,9876503276 B 9567890765 9876098567 Null
what is dynamic cashe