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?

0 Answers  

---

Define joiner transformation?

0 Answers  

---

Name the different lookup cache(s)?

0 Answers  

---

If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?

1 Answers  

---

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

---

What do you mean by blocking transformation?

0 Answers  

---

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers   TCS,

---

When do we use dynamic cache and static cache in connected and unconnected lookup transformations?

3 Answers  

---

What is blocking transformation?

0 Answers   Informatica,

---

suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,

---

Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,

---

Describe two levels in which update strategy transformation sets?

1 Answers  

---