URGENT - Trying to explain this to client..
Posted: Mon Jan 12, 2004 8:31 pm
I am trying to explain this to the client, and it ain't pretty. Here's the issue:
They are planning to send the data in the following format into the ETL process:
<customer>
<name> John Smith</name>
<addr> 123 main St. <addr>
<addr> 328 Y ave.</addr>
<system> A</system>
</customer>
so basically one customer having more than one address coming from the same system.
I told the client that in order to create the data in the perfect condition I will have to split the single cust. data into two as:
John Smith 123 Main St. A
John Smith 328 Y Ave. A
John Smith 340 K St. B
John Smith 450 Bore Dr.C
etc.
The client is concerned by the volume of the data that will be generated due to the multiple lines that are being generated. Quite frnakly I don't know what would be a way to avoid multiple lines and keep them happy. This is the only way I can think of as a solution ..
They are planning to send the data in the following format into the ETL process:
<customer>
<name> John Smith</name>
<addr> 123 main St. <addr>
<addr> 328 Y ave.</addr>
<system> A</system>
</customer>
so basically one customer having more than one address coming from the same system.
I told the client that in order to create the data in the perfect condition I will have to split the single cust. data into two as:
John Smith 123 Main St. A
John Smith 328 Y Ave. A
John Smith 340 K St. B
John Smith 450 Bore Dr.C
etc.
The client is concerned by the volume of the data that will be generated due to the multiple lines that are being generated. Quite frnakly I don't know what would be a way to avoid multiple lines and keep them happy. This is the only way I can think of as a solution ..