We have built a Generic extractor which is built over a Z table. This table does not contain any date fields. The extractor works fine when we carry out a full load. We would now like to Delta enable this extractor. The details are as follows:
1) Our base table (Z table) has no date fields
2) The keys for the table are Equipment No and Material No
3) We plan to create a view which will have a join condition with either MARA or EQUI
The question is if we do create a view and than base the extractor on the view rather than the table which table is better and which field should we use from that table for Delta. Will this work? Thanks