Answer Posted / hari

create mapping like

source -- sorter -- expression -- filter -- target.

here sorter is used to send data by ascending order data
this is not mandatory.

Expression is need to create variable port which will count
the rows which are comming in.

Filter having condition like if count value >=51 and count
value <= 100.

Differentiate between source qualifier and filter transformation?

1509

---

What is a repository manager?

1029

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1028

---

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

1058

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2064

---

Define sessions in informatica etl?

970

---

Write the unconnected lookup syntax?

1030

---

Enlist the differences between database and data warehouse.

1033

---

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1574

---

What is persistent lookup cache?

966

---

How are indexes created after completing the load process?

1545

---

What are mapplets?

1211

---

What are the databases that informatica can connect to windows?

1001

---

what are the Methods For Creating Reusable Transformations?

1099

---

What is a repository? And how to add it in an informatica client?

1082

---