Answer Posted / isha

Actually this question is - If any record have duplicate value then put it in T1 and If count is 1 then put in T2.

We have to use aggregator and have to group records based on empid and name

If count(empid) > 1 then T2
If count(empid) =1 then T1

Explain in detail scd type 2 through mapping.

1027

---

Global and Local shortcuts. Advantages.

2017

---

What is powercenter on grid?

1165

---

Mention few advantages of router transformation over filter transformation.

1019

---

Why is sorter an active transformation?

1100

---

How does a rank transform differ from aggregator transform functions max and min?

1192

---

How to create a non-reusable instance of reusable transformations?

1097

---

Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1837

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4094

---

Could you explain what is enterprise data warehouse?

1118

---

What is an unconnected transformation?

1065

---

suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7182

---

server hot-ws270 is connect to Repository B. What does it mean?

2532

---

Explain dynamic target flat file name generation in informatica

1034

---

What is main use of mapplet?

1119

---