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 are events in workflow manager?

1 Answers   Accenture, IBM,

---

What are the different caches used in informatica?

3 Answers   UST,

---

How to merge First Name & Last Name?

8 Answers  

---

How to do Half of the table ex: if 1000 records are there means 500 in one table and 500 in second table like this if N number of tables means how to do Half of the table ??????????

2 Answers   TCS,

---

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

---

Describe data concatenation?

0 Answers  

---

define galaxy repository in informatica

0 Answers  

---

How informatica recognizes mapping?

2 Answers   CTS,

---

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

source table have single column single record having with single space. load that source record into trg . trgt having two columns and the SOURCE TABLE LIKE COL1 BHANU PRASAD TRGT TABLE COL1 COL2 IN THAT LOAD THE RECORD IN THE trgt table LIKE COL1 COL2 BHANU PRASAD HOW ? TELL ME PLZ

2 Answers   Wipro,

---

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---