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.

Answer / isha

you can use unstructured data format transformation fro that purpose.

WHAT IS THE NAME OF THAT PORT IN DYNAMIC CACHE WHICH IS USED FOR INSERT , UPDATE OPRATION ?

4 Answers   Oracle,

---

What are the different types of transformation available in informatica.

0 Answers  

---

Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?

2 Answers  

---

What are the session parameters?

3 Answers  

---

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

---

What are the active and passive transforamtions?

2 Answers  

---

how we can load rejected record's at run time?(not through bad files)

0 Answers   TCS,

---

what are the deliverables?in your project?

0 Answers   DELL,

---

Plz can anybody send Informatica and Cognos FAQ Plz To thid ID ppradeep_dwh@yahoo.co.in

1 Answers  

---

What is difference between stored procedure transformation and external procedure transformation?

2 Answers  

---

there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,

---

How do we call shell scripts from informatica?

0 Answers  

---