How to read data from flat file source if the data is in paragraph format?
- 2 Answers
- 4316 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
what is row level and column level indicator?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.
when we go for unconnected lookup transformation? and why?
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
What is domain in terms of informatica?
Explain load alternative records / rows into multiple targets - informatica
How the Informatica Server reads perameter file?
Which version configuration tool used in ur project?
can anyone explain me about sales project in informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Teradata 
