SRC - SQ_SRC - EXP - FIL- TGT
Go with this logic...Every thing will be loaded in TARGET table
Type: Posts; User: Rajan Raorane; Keyword(s):
SRC - SQ_SRC - EXP - FIL- TGT
Go with this logic...Every thing will be loaded in TARGET table
Kripa,
Duplicate Records : There no need to do any thing jus Do not use look up table
with removal Look up table all you Source rows will append to existing record which will create duplicacy
...
You can join the three tables using Joiner transformation proivded that the condition should be mention in Joiner properties
Joiner are basically used to join the hetrogeneous data Source