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

Can anyone tell me the new features in Informatica 9 Version?

1785


What is the fact table?

793


What is the advantage of informatica?

831


What are the features of complex mapping?

871


What is a dimensional model?

750


How do you load first and last records into target table?

926


How to generate sequence numbers without using the sequence generator transformation?

879


How to update or delete the rows in a target, which do not have key fields?

901


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1360


What all are steps in up gradation of Informatica server?

813


What is the difference between STOP and ABORT options in Workflow Monitor?

950


How can you increase the performance in joiner transformation?

938


What is target designer and target load order?

854


How to do unit testing in informatica? How to load data in informatica ?

888


how we can load rejected record's at run time?(not through bad files)

2144