Answer Posted / purva

Tasks in Informatica can be categorized as,
1. Assignment Task
2. Command Task
3. Control
4. Decision
5. Email
6. Event-Raise
7. Event- Wait
8. Session
9. Timer

What you know about transaction control transformation?

1055

---

What is the meaning of decode in informatica?

1164

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4147

---

What are session parameters ? How do you set them?

1899

---

What do you understand by term role-playing dimension?

1114

---

Explain the features of connected and unconnected lookup.

973

---

Explain lookup transformation in informatica

1123

---

How can you differentiate between powercenter and power map?

1138

---

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

2006

---

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

1907

---

Why update strategy and union transformations are active?

1091

---

Tell me about Propagate functions in informatica

976

---

How can you increase the performance in joiner transformation?

1246

---

What is an unconnected transformation?

1128

---

What is the meaning of up gradation of repository?

2052

---