Answer Posted / abhilash

do following steps

1.in source qualifier override the query with
"order by salary desc"

2. use seq gen tr on it and give column name as "sid"

3. next use filter tr. in that write condition like "sid<=10"

What is different between the data warehouse and data mart?

1066

---

What is exclusive and normal mode for repository services?

1144

---

Explain dynamic target flat file name generation in informatica

1055

---

Is it possible to define a single node as a Gateway node as well as worker node?

1122

---

How an expression transformation differs from aggregator transformation?

1043

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5675

---

What are the tasks that source qualifier perform?

1106

---

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

8223

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1855

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10167

---

What is workflow manager?

1047

---

What is a surrogate key?

1081

---

What is the commit type if you have a transaction control transformation in the mapping?

1030

---

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 are the components of the workflow manager?

1135

---