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

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1145

---

What is a stored procedure transformation?

1034

---

How can you validate all mappings in the repository simultaneously?

1349

---

Separate from a database, an information bazaar, and an information stockroom?

1070

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2100

---

Explain direct and indirect flat file loading (source file type) - informatica

1303

---

Repository user profiles

1745

---

Explain load alternative records / rows into multiple targets - informatica

1135

---

What do you understand by term role-playing dimension?

1025

---

What are the databases that informatica can connect to windows?

1034

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1490

---

Explain sessions?

1027

---

How to go to the older version for a mapping?

1064

---

How identifying bottlenecks in various components of informatica and resolving them?

1101

---

Explain about Informatica server process that how it works relates to mapping variables?

1047

---