Answer Posted / vijay

You can also use expression transformation. Write the logic
i = 0 and increment it in another column. Give this column
as output.

What is status code in informatica?

959

---

What is a dimensional model?

926

---

What is dimensional table?

1001

---

How do you load unique records into one target table and duplicate records into a different target table?

1163

---

Explain what are the different versions of informatica?

1031

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1714

---

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

1996

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1893

---

how to load rows into fact table in data warehouse

1114

---

Slowly changing dimensions, types and where will you use them

1653

---

What do you mean by blocking transformation?

970

---

what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1907

---

Define joiner transformation?

986

---

How might one distinguish in the case of mapping is right or not without associating session?

1025

---

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

---