Answer Posted / babu

Hi,
If your source is RDBMS,u can writ sql override in
sourequalifier.


select p.*,pc.cno from product p,(select price,count(price)
cno from product group by price) pc where pc.price=p.price;

In RTR group1 cno=1
group2 cno>1

OR
If source is flatfile

SRC-->SQ-->AGG(GROUP BY PRICE,CNO=COUNT(PRICE))
|
SRC-->SQ-->JNR--RTR (GRP1 CNO=1 )-->TRG1
(GRP2 CNO>1 )-->TRG2

What is meant by a domain?

1111

---

Write the unconnected lookup syntax and how to return more than one column.

1097

---

How might you approve all mappings in the archive all the while?

1005

---

Differentiate between a database and data warehouse?

1128

---

What is lookup change?

1032

---

In development project what is the process to follow for an etl developer from day1

1701

---

What are the different versions of informatica?

1246

---

What is meant by lookup transformation?

1085

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1097

---

What are the components of workflow manager?

1074

---

How to do unit testing in informatica? How to load data in informatica ?

1093

---

How can we delete duplicate rows from flat files?

1204

---

Name the different lookup cache(s)?

1214

---

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?

1493

---

What will be the approach?

963

---