Answer Posted / shiva

Joiner transformation:

it has its own cache.

look up transformation:

it maintains its own cache

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8222

---

What is a passive transformation?

1103

---

what are the Methods For Creating Reusable Transformations?

1171

---

can u give example for factless fact table

6647

---

Difference between Data and Index Caches?

1137

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1152

---

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?

1766

---

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1995

---

draw informatica architecture 8.6 ?

3871

---

Explain incremental aggregation in informatica

1128

---

What is the difference between Active and Passive transformation?

1152

---

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

1863

---

What is primary and backup node?

1127

---

Briefly define reusable transformation?

1127

---

What will be the approach?

979

---