Answer Posted / sudhir kumar

we can do this by using crontab file in unix,
For this we need to sheduled the Powercentre job.

or
we can use "at" commmand in unix to schedule the job.

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

1049

---

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

1805

---

Explain the different dimensions.

913

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2139

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1133

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

1033

---

r u done any partitions in ur project?

1751

---

How we can use union transformation?

989

---

What do you mean incremental aggregation?

1010

---

draw informatica architecture 8.6 ?

3820

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6039

---

What is mapping debugger?

943

---

Why update strategy and union transformations are active?

989

---

What are the different types of transformation available in informatica.

1029

---

Explain constraint based loading in informatica

1036

---