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 are the types of schemas we have in data warehouse and what are the difference between them?

942

---

What is the meaning of up gradation of repository?

1992

---

Why sorter is an active transformation?

1195

---

What is Session and Batches?

1108

---

expain about the tune parameters?

2415

---

What if the source is a flat-file?

1112

---

difference between informatica 8.1.1 and 8.6

3677

---

What do you understand by a term domain?

1125

---

How to partition the Session?

1113

---

what is degenerated dimension?

3998

---

How to create or import flat file definition in to the warehouse designer?

1070

---

How to load a Dimension ? and how to load a fact table?

1419

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1065

---

What is enterprise data warehousing?

1049

---

How would you copy the content of one repository to another repository?

1019

---