Answer Posted / swetha

yoU can not create or import flat file defintion in to
warehouse designer directly. Instead U must analyze the file
in source analyzer,then drag it into the warehouse designer.
When U drag the flat file source defintion into warehouse
desginer workspace, the warehouse designer creates a
relational target defintion not a file defintion. If u want
to load to a file, configure the session to write to a flat
file. When the informatica server runs the session, it
creates and loads the flatfile.

Explain what are the different versions of informatica?

1055

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1063

---

What is meant by incremental aggregation?

1051

---

Enlist some properties of sessions.

1041

---

How to partition the Session?

1066

---

Can informatica load heterogeneous targets from heterogeneous sources?

1142

---

Explain the use of aggregator cache file?

1205

---

What is a sequence generator transformation?

987

---

How do you load unique records into one target table and duplicate records into a different target table?

1180

---

what are the Methods For Creating Reusable Transformations?

1119

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2220

---

How are indexes created after completing the load process?

1577

---

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

1039

---

Is there any way to read the ms excel datas directly into informatica?

994

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1865

---