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
Can anyone tell me the new features in Informatica 9 Version?
What is the fact table?
What is the advantage of informatica?
What are the features of complex mapping?
What is a dimensional model?
How do you load first and last records into target table?
How to generate sequence numbers without using the sequence generator transformation?
How to update or delete the rows in a target, which do not have key fields?
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)
What all are steps in up gradation of Informatica server?
What is the difference between STOP and ABORT options in Workflow Monitor?
How can you increase the performance in joiner transformation?
What is target designer and target load order?
How to do unit testing in informatica? How to load data in informatica ?
how we can load rejected record's at run time?(not through bad files)