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
- 4665 Views
- Wipro, I also Faced
- E-Mail Answers
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
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is meant by pre and post session shell command?
What is informatica? Why do we need it?
What will be the approach?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is primary and backup node?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What is the procedure for creating independent data marts from informatica 7.1?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
Does an informatica transformation support only aggregate expressions?
How do you convert single row from source into three rows into target?
What is a connected transformation?
What do mean by local and global repository?
Briefly explain the aggregator transformation?
