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
Explain the different dimensions.
How do you promote a non-reusable transformation to reusable transformation?
What is target designer and target load order?
is it possible to index the data in cache of lkp transformation ?
Explain pushdown optimization $pushdownconfig parameter - informatica
What is deployment group?
Explain scd type 3 through mapping.
Why update strategy and union transformations are active?
Can we create two repositories on same database instance in oracle?
How can we delete duplicate rows from flat files?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to use procedural logic inside infromatica?
What is the maplet?
what is index?how it can work in informatica
In what scenario we use to improve session performance by pushdown optimization?can any one give example?