ETL Script for different schema

[manojkulkarni]

Hi Friends,

I have a scenario where in customer modifies source file very frequently. Source will be updated with additional column or column will be deleted How should we handle in script while creating QVDs ? Can we have single script to uploaded below templates

eg:

Template1

Col1 Col2 Col3 Col4 Col5

Template2

Col1 Col2 Col3 Col5 Col6 Col7

Expected QVD Format

Col1 Col2 Col3 Col4 Col5 Col6 Col7

[lironbaram]

hi

you can do something like this :

Data:

load *

From Template1;

join

load * From Template2;

store Data into Data.qvd;