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.

Which transformation should we use to normalise the COBOL and relational sources?

0 Answers   Informatica,

---

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

---

if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000

7 Answers  

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

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

2 Answers  

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

0 Answers   IBM,

---

List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys

1 Answers  

---

Differentiate between mapping parameter and mapping variable?

1 Answers  

---

What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.

2 Answers   Mphasis,

---

What is update override?

1 Answers   Accenture,

---