How to read data from flat file source if the data is in paragraph format?
Answer Posted / sajid
In order to read data from flat file, your must have to be in readable format first. Informatica cannot read/understand the flat file which contains the unstructured data.
By using UNIX shell script or third party tool you will have to bring your data in readable format. When I say in readable format means you will have to use some delimiter in flat file to separate the one column value to another column.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
COM components can be used in Informatica
How to use procedural logic inside infromatica?
What are the guidelines to be followed while using union transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
what is size of u r database?
Enlist the advantages of informatica.
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What are the various types of transformation?
tell me about your project functionality
explain about unit testing? in real time?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the new features of informatica 9.x developer?
What is the function of look up transformation?
According to his methodology what all you need before you build a datawarehouse