Answer Posted / swetha

Grouping of session is known as batch.Batches are two types

Sequential: Runs sessions one after the other

Concurrent: Runs session at same time.

If you have sessions with source-target dependencies you
have to go for sequential batch to start the sessions one
after another.If you have several independent sessions you
can use concurrent batches Which runs all the sessions at
the same time.

expain about the tune parameters?

2415

---

What is a sequence generator transformation?

1022

---

Explain direct and indirect flat file loading (source file type) - informatica

1319

---

what is the size of your data warehousing?

2095

---

What is the way to execute pl/sql script using informatica mapping?

1607

---

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

8223

---

Explain the scenario which compels informatica server to reject files?

1169

---

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

1864

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1100

---

What is substr in informatica?

1209

---

What is rank index in rank transformation?

1080

---

What are the new features of informatica 9.x in developer level?

999

---

Where is metadata stored?

1114

---

What is a transaction control transformation?

1208

---

What is intricate mapping?

1206

---