Answer Posted / sks

Hi,
Yes you can do it by using Expression transformation as
well. Infact, by using 2 SQ (source qualifier) and using
sql queries (as I explained earlier), you can perform the
required task on relational tables only (but not on flat
files etc).
In the case of flat files as source, you will need to use
Expression transformation. But you also need to use sorter
before expression (otherwise record flag will change for
every incoming record & duplicates won't be traced). The
sequence of transformations will be as follows -

Source -> SQ -> Sorter ->Expression ->Router(or 2 filters) -
>Targets

Enterprise data warehouse your projects phase by phase explain?

1917

---

What is DR strategy for Informatica project?

1172

---

What is a node in Informatica?

1037

---

Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1668

---

What is parallel processing in informatica?

1710

---

What are the issues you have faced in your project? How did you overcome those issues?

2359

---

What are junk dimensions?

1064

---

How does a sorter cache works?

1064

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2144

---

What are the various types of transformation?

1174

---

What are the different ways to implement parallel processing in informatica?

1423

---

how to create user defined function (udf) in informatica

1299

---

Explain in detail about scd type 1 through mapping.

1548

---

Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2335

---

Enlist the various types of transformations.

1051

---