Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / kpmp

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

How can we trouble shoot the commas in a column of a comma delimited flat file in Informatica

1 Answers  

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

What is the difference between Bitmap and Btree index?

3 Answers   Mind Tree,

Performance tuning in UNIX for informatica mappings?

0 Answers   CGI, CTC,

I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..

4 Answers   Wipro,

Write a query to display Which deptno is containing highest Sal > avg (sum (Sal)) of all deptno; Avg (sum (Sal)) o f all deptno= 9675 Deptno, sum (Sal) 10 8750 20 10875 30 9400

7 Answers   iGate,

What are Target Options on the Servers?

1 Answers  

My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000

3 Answers   Wipro,

a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .

2 Answers   TCS,

what happens if you try to create a shortcut to a non- shared folder?

1 Answers  

What is an aggregator transformation?

0 Answers  

expain about the tune parameters?

0 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories