HI
I have target FCT_JOB_EQUIPMENT WITH COULUM REC_TYPE THE STABLE IS SOURCED OUT OUT OF THREE 1)STG_JOB_EQUIPMENT2)STG_CUST_RETURN3)STG_JOB_RETURN IF THE SOURCE IS STG_JOB_SHIPMENT THEN INSERT "SHIPPED EQUIPMENT"
IF THE SOURCE IS STG_CUST_RETURN THEN INSERT RETURNED BY CUSTOMER
IF THE SOURCE IS STG_JOB_RETURN THEN INSERT RETURN RETURNED BY INSTALLER
ALL THE OTHER COULMS I AM USING STG_JOB_SHIPMENT AS SOURCE ON THIS COLUM REQ IS LIKE THIS IT WANTS THREE SOURCES PLZ ADVICE.
THANKS,
BOBBY
RECORD_TYPE FROM 3 SOURCES
Moderators: chulett, rschirm, roy
Hi,
My assumption is that you ahve three input tables
1) STG_JOB_EQUIPMENT
2) STG_CUST_RETURN
3) STG_JOB_RETURN
Target table is FCT_JOB_EQUIPMENT
From three input sources, you are writing to the target table.
When the record is inserted from STG_CUST_RETURN, you want to write value "Returned by Customer
When the record is inserted from STG_JOB_RETURN , youwant to write value "Returned by Installer" ......
Solution-
In the transformer stage, for the column REC_TYPE,
you can put if then else if condition like
If STG_CUST_RETURN.input column then "Returned by Customer" else if
" STG_JOB_RETURN.input_column then "Returned by Installer" ...
Ketfos
My assumption is that you ahve three input tables
1) STG_JOB_EQUIPMENT
2) STG_CUST_RETURN
3) STG_JOB_RETURN
Target table is FCT_JOB_EQUIPMENT
From three input sources, you are writing to the target table.
When the record is inserted from STG_CUST_RETURN, you want to write value "Returned by Customer
When the record is inserted from STG_JOB_RETURN , youwant to write value "Returned by Installer" ......
Solution-
In the transformer stage, for the column REC_TYPE,
you can put if then else if condition like
If STG_CUST_RETURN.input column then "Returned by Customer" else if
" STG_JOB_RETURN.input_column then "Returned by Installer" ...
Ketfos
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
Bobby,
Are you saying that you want to append rows from STG_JOB_EQUIPMENT to FCT_JOB_EQUIPMENT, and update rows from STG_CUST_RETURN and STG_JOB_RETURN in FCT_JOB_EQUIPMENT?
Are you saying that you want to append rows from STG_JOB_EQUIPMENT to FCT_JOB_EQUIPMENT, and update rows from STG_CUST_RETURN and STG_JOB_RETURN in FCT_JOB_EQUIPMENT?
Chuck Smith
www.anotheritco.com
www.anotheritco.com
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact: