Answer Posted / ramesh

target1
SQ->Router->
target2

1.In router create one group and specity
the condition empid=201 or empid=202.
2.It is connected to target1.
3.Default group is connected to target2.

Thanks & Regards
Ramesh

Define sessions in informatica etl?

1038

---

what is degenerated dimension?

3998

---

State the limitations where we cannot use joiner in the mapping pipeline?

1068

---

Explain pmcmd command usage in informatica

1139

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1060

---

What is lookup change?

1052

---

Explain what is informatica metadata and where is it stored?

1051

---

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

1866

---

What is aggregator transformation in informatica?

953

---

Explain lookup transformation is active in informatica

1108

---

Explain scd type 3 through mapping.

1021

---

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5798

---

what is size of u r database?

2311

---

can we override a native sql query within informatica? Where do we do it?

1123

---

What are some examples of informatica etl programs?

944

---