Answer Posted / 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.

what are the deliverables?in your project?

2091

---

What is an aggregator transformation?

1036

---

Performance tuning( what you did in performance tuning)

1921

---

What do you understand by a term domain?

1075

---

Explain dynamic target flat file name generation in informatica

1015

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2069

---

What does cheating measurement mean?

1002

---

Explain what transformation and how many are there in informatica?

897

---

Repository user profiles

1724

---

Differentiate between source qualifier and filter transformation?

1518

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1639

---

What is the status code in stored procedure transformation?

1130

---

4 yrs etl devloper roles and responsibilities?any body give solutions

2089

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1111

---

which one is better performance wise joiner or look up

1034

---