Answer Posted / deepu

The good advantage of using Informatica it enables to work
with both relational and non-relations source and targets.
So , now to load a data from relation to flatfile follow
the steps:
1,Extract the Sourec table (i.e orcale, teradata any
reational)
2, create a target table (FlatFile) let it be fixed with r
delimiter as per the data in the source table then creat
the columns and make the point that the datatype must match
to that of the datatype in the source table .
3, Built a mapping considering the needed
transformations .
4, configure the source and target in the workflow manager .
5 . and execute the job....
check out properlly the properties setting at workflow
manager .

Thanks & Regards
Deepu

What is the session task and command task?

1054

---

Differentiate between sessions and batches?

1016

---

What are the components of the workflow manager?

1133

---

Performance tuning in UNIX for informatica mappings?

2566

---

permutations of mapplet

2509

---

what are the deliverables?in your project?

2150

---

What happens when a session fails and you click on recover?

1120

---

Why filter transformation is an active one?

982

---

How can you define user defied event?

1027

---

What is the use of an aggregator cache file?

1199

---

What is the difference between Active and Passive transformation?

1150

---

tell me about your project functionality

2341

---

What is the need for an etl tool?

1068

---

Which is the t/r that builts only single cache memory?

1190

---

What is a sorter transformation?

1102

---