Interested to Buy Any Domain ? << Click Here >> for more details...
How to read data from flat file source if the data is in paragraph format?
- 2 Answers
- 4775 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 |
Useful UNIX commands regular/frequently used
which transformation should we use to get the 5th rank member from a table in informatica?can we achieve this in sql?
Tell me about Propagate functions in informatica
What is data caches/ index caches?
If I have a index defined on target table and if set it to bulk load will it work ?
If we are using an aggregator but forget to mention the group by port .what will be the output??
What are the challenges you have faced in your project?
How many ways a relational source definition can be updated and what are they?
how to convert 101 raja 101 raja sekar reddy 101 sekar----------> 101 reddy
how to load the data in fact table.. using look up transformation how to view the second record. usally look up shows matching record for only one value. if i have same value its not displaying. ex: problem i faced. i have total, student no and name in table student i used aggregation transformation to display max(total). i have two same max values in total. when i look up the student name and no for this max(total), its showing only one name and no, its leaving the second one. how to rectify it. plz tel me step by step or clearly.
What is difference between partioning of relatonal target and partitioning of file targets?
Explain your project of banking domian.
Teradata 
