How to read data from flat file source if the data is in paragraph format?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / isha
you can use unstructured data format transformation fro that purpose.
Is This Answer Correct ? | 0 Yes | 0 No |
How You Pull the records on daily basis into your ETL Server.
Filter transformation in the condition one of the data is NULL would the record be dropped.
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
How to do the error handling of if ur source is flatfiles?
Where is metadata stored?
Explain the features of connected and unconnected lookup.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is diffrence b/w joner and union transfermation
Difference between Data and Index Caches?
How the Informatica Server reads perameter file?
what is SDLC way of code development?
Different sorts of metadata that stores in the storage facility?