Answer Posted / ratalarayudu

hi ,

Yes we can update a target table without having a primary
key. we have a property TARGET UPDATE OVERIDE .By overring
we can update .


Regards,
Rayudu.

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2041

---

Does an informatica transformation support only aggregate expressions?

991

---

How can repository reports be accessed without sql or other transformations?

1179

---

Enterprise data warehouse your projects phase by phase explain?

1874

---

What is resilience time?

1073

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2106

---

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

1822

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2218

---

have u done any performance tuning? how u ll do?

2259

---

What are ETL Tools?

1067

---

How we can create indexes after completing the load process?

1130

---

Difference between Target-based loading and constraint-based loading?

967

---

Describe data concatenation?

1035

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1053

---

Differentiate between joiner and lookup transformation?

1066

---