Answer Posted / jz

1) Query performance is high.
2) It consume less space compare to SnowFlake.

How can a transformation be made reusable?

1140

---

Explain your project of banking domian.

1639

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1977

---

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

1836

---

What is a repository manager?

1075

---

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

1203

---

what is song in infrmatica...?

2217

---

According to his methodology what all you need before you build a datawarehouse

1739

---

What is dimensional table? Explain the different dimensions.

1156

---

Do you find any difficulty while working with flat files as source and target?

1082

---

Explain constraint based loading in informatica

1076

---

waht type of interface is used for testing the data in informatica

2237

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1017

---

Explain why we use partitioning the session in informatica?

1069

---

What is the procedure for creating independent data marts from informatica 7.1?

1044

---