Answer Posted / m.mahendra

The fact table which contains the business events or
coverage that could be represented in a fact table, but
there will be no measures or facts associated with these.

What is incremental aggregation?

1137

---

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

1250

---

What are the various types of transformation?

1243

---

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

1910

---

Define mapplet?

1059

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7184

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1213

---

What is exclusive and normal mode for repository services?

1190

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

2011

---

Please let me know how to make Data masking in informatica..

1775

---

Can anyone tell me the new features in Informatica 9 Version?

2213

---

What is the need of etl tools?

1182

---

What is sorter transformation?

1111

---

What is transformation?

1159

---

Explian the Process of deployment groups in informatica

1102

---