Answer Posted / ramanaiah

without using sorter,and aggregrator transformations.we can
useing dynamic lookup to avoid duplicate rows.

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1695

---

What is persistent lookup cache?

1026

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

2412

---

expain about the tune parameters?

2408

---

Define mapplet?

1004

---

Difference between Target-based loading and constraint-based loading?

992

---

What are the new features of Power Center 5.0?

1768

---

How many number of sessions can one group in batches?

1155

---

Describe expression transformation?

1114

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1954

---

Could you explain what is enterprise data warehouse?

1135

---

whats the logic to load the lower level of granularity of data to fact table.

2269

---

What is option by which we can run all the sessions in a batch simultaneously?

1135

---

How would you join a node to the already existing domain?

1123

---

What is substr in informatica?

1200

---