Answer Posted / venkateshmalneni

FOR THIS WE HAVE 2 USE TWO T/R ie FIRST WE HAVE 2 USE RANK T/R
AND THEN USE A FILTER T/R IN FILTER GIVE THE CONDITION AS
RANK=5 CONNECT TO TARGET
THE FLOW IS LIKE THIS
SRC --->SQ--->RANK--->FILTER--->TRG

WE CAN ALSO DO THIS IN SQL USE THE FOLLOWING QUERY

SELECT * FROM <TABLE_NAME> WHERE ROWNUM <= 5 MINUS SELECT *
FROM <TABLE_NAME> WHERE ROWNUM <=4;

Why is sorter an active transformation?

1134

---

What is the need of an ETL tool?

1109

---

What is a surrogate key?

1089

---

What you know about transaction control transformation?

998

---

Which means the first record should come as last record and last record should come as first record and load into the target file?

1081

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4115

---

What is aggregate cache in aggregator transformation?

1151

---

have u done any performance tuning? how u ll do?

2300

---

What is workflow? What are the components of the workflow manager?

1146

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2363

---

Reusable transformation and shortcut differences

1845

---

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

1867

---

tell me the rules and responsblites in our project(my project is development)

1936

---

What are the differences between oltp and olap?

976

---

Explain in detail about scd type 1 through mapping.

1559

---