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


Please Help Members By Posting Answers For Below Questions

COM components can be used in Informatica

2119


How to use procedural logic inside infromatica?

878


What are the guidelines to be followed while using union transformation?

899


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1773


what is size of u r database?

2066


Enlist the advantages of informatica.

857


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.

2628


What are the various types of transformation?

912


tell me about your project functionality

2118


explain about unit testing? in real time?

1932


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2100


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?

841


What are the new features of informatica 9.x developer?

756


What is the function of look up transformation?

890


According to his methodology what all you need before you build a datawarehouse

1451