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 some examples of informatica etl programs?

900

---

Explain the types of lookup transformation?

988

---

can we override a native sql query within informatica? Where do we do it?

1080

---

What is a filter transformation and why it is an active one?

919

---

Suppose we do not group by on any ports of the aggregator what will be the output?

997

---

how tokens will generate?

2163

---

What will be the approach?

939

---

How to implement security measures using repository manager?

1101

---

What is rank transformation in informatica

1120

---

Explain pushdown optimization and types in informatica

1031

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1884

---

How many ways are there to do 'remove duplicate records in informatica'?

967

---

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1042

---

How can you generate reports in informatica?

982

---

What is the use of transformation?

959

---