How do you design PX Routines ?

1 Answers  

---

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

---

How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

0 Answers   Reliance,

---

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

---

Hi, My source is oracle(eno,ename,sal,commision,...), my requirement is like this, if there is a null values in commission col i want to keep it as null,and for the remaining first two characters of the value in my target. Plz help me

1 Answers  

---

What is aggtorec restructure operator?

0 Answers  

---

options available in sequence job to run,validate?

0 Answers   CTS,

---

wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,

---

What are transforms and what is the differenece between routines and transforms?

0 Answers  

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

0 Answers   IBM,

---

What is the default execution order of the sequential file?

3 Answers  

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  

---