concatenated tables and then join

[Anonymous]

Hi ,

I have a wierd scenario that is

Table1:

load A, B, C

from table1;

concatenate(Table1)

load A, B, C

from table2;

concatenate(Table1)

load A, B, C

from table3;

join(table1)

Load A, B, D, E from facttable_*;

after join statement facttable_* , Here * indicates years 2011, 2012, 2013. it will have 3 tables which needs to be concatenated and then join. Problem from me is , the second (2012 ) QVD and third 2013 QVD is not joining properly. Because of that i am not getting the data from the second and 3rd QVD. Need your inputs on how to solve this issue.

[shree909]

Hi i dont know just give a try.

Concatenate all the 3 tables and take resident  of 3 tables and join with ur fact table;

Thanks

[Anonymous]

did tried that by taking first three tables as concatenate .. pushed into QVD and used that QVD and joined that to my fact table...Do you think fact table might have an issue.

[shree909]

looks like have an issue with fact table;

if possible could you post a  sample file.

Thanks

[Anonymous · Accepted solution]

Its very big file. I have the solution here but wanted to find out , why above scripting is not working. What i did was push above three concatenates to one QVD and even the fact also the same way and then join them , it is working fine.

[maxgro]

change

join(table1)

Load A, B, D, E from facttable_*;

to

join(Table1)

Load A, B, D, E from facttable_* (qvd);

it should work; if you still have problems you can load the 3 qvd files without join and see the result in table viewer

facttable:

Load A, B, D, E from facttable_* (qvd);