DSXchange

In Banking Domain,a new customer deposits some amount say Rs.5000.The same day the customer withdraws Rs.1000.Will the customer be generated with 2 different surrogate keys generating duplicate records if the target table is used as Reference table while performing a lookup?

The page didn't allow me to draw the design of the job perfectly.
That's PX job design.
If it's a server job then a hash file can be used to do the lookup.

Design the job as shown below: ------------------Surrogate table FlatFile -------> Lookup ---------->Transformer---------> DB2 ............................... ..................... Aggregator--------->Surrogate Table In the lookup stage ,lookup the table_name(target table name) field and retrieve th...