Answer»
- Import src from database.
- Check if target table already exists in database.
- If it exists make sure u delete data from it and import into designer.
- Or ELSE create it with create target wizard.
- Now you can drag needed transformations into the workspace.
- Use them according to your purpose.
For improved performance follow these tips:-
- Use sorter before aggregator
- If filter is used KEEP it as near to the source as possible.
- If possible use an extra expression tr before target to make corrections in future.
- ENABLE sorted input option if sorter is used before agg tr.
- If more FILTERS are needed use ROUTER tr.
- you can use source filter option of SQ if filter tr is immediately after source.
- In case of router if not needed do not connect default group to any target.
For improved performance follow these tips:-
|
