How to read data from flat file source if the data is in paragraph format?

Question Posted / kpmp

2 Answers
4819 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to read data from flat file source if the data is in paragraph format?..

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

How to read data from flat file source if the data is in paragraph format?..

Answer / isha

you can use unstructured data format transformation fro that purpose.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Informatica Interview Questions

why we need informatica

2 Answers HCL,

explain different types of modeling.

2 Answers

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

6 Answers IBM,

What is a rank transform?

0 Answers

What are the mapping paramaters and mapping variables?

1 Answers

can we see default group,when we use router?if yes how?

2 Answers L&T,

When do you use sql override in a lookup transformation?

0 Answers

What do you understand by a term domain?

0 Answers

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers iFlex, Morgan Stanley,

I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?

5 Answers Syntel,

Can anyone briefly describe abt audit table loading?

2 Answers TCS,

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers TCS,

For more Informatica Interview Questions Click Here