How to read data from flat file source if the data is in paragraph format?
- 2 Answers
- 3834 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 |
Define filter transformation?
What is xml source qualifier transformation in informatica?
Describe the impact of several join conditions and join order in a joiner transformation?
What is meant by incremental aggregation?
What is the Rankindex in Ranktransformation?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
A Flat file located in unix source folder. data transfer every day 8 am. can ask 5 question for above scenario validation. recently i have faced this question.
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
What is informatica powercenter repository?
how can u avoid duplicate rows in flat file?
Tell me about MD5 functions in informatica
how to use incremental load?
Teradata 
