Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I have data source in which multiple tables are prese3nt , and all tables have lot of columns (Approx. 200) in each table . And about 100 column names are same in the tables.
So to remove the synthetic key I can do the following solution :
1 : Renaming the field
2 : Using Qualify Function
But renaming fields is not a good option it will take lot of time .
And Client requirement is , not to use the qualify function.
So can you all suggest me any other way to do this .
Thanks
Perhaps, Concatenate ?
Hi Agnivesh,
I would advise against using QUALIFY anyway, it brings you only trouble in the long run.
I know of no third alternative - then you have to rename fields.
It's not so much work in the overall view of things because you have to do it only once.
Or you could load all tables with QUALIFY, load a mapping table with the qualified names and a chosen alias, then use MAP USING and do a RESIDENT LOAD for each table with UNQUALIFY - but that would be even more work 😉
Sorry - I guess you'll have to choose one frog or the other ...
Best regards,
DataNibbler
Hi Agnivesh,
Create resident tables with fields currently u r using in application and concatenate all resident tables and drop mail tables.
Regards,
Chennaiah
If I will use Concatenate then my data model will be of 1 table
Yes.
with all fields which r currently u r using. in single table.
so no need to use qualify statement.
So is this ok that for my big dashboard data model only one table is present .
Hi Agnivesh,
just a word of caution: Do you know for sure that the equally named columns also have the same meaning in all of the tables? (If the tables were to come from SAP, for ex., that would not necessarily be the case)
The other requirements - same no. of columns and same structure - are easy probably.
If it works, it is probably okay 😉 It's in some aspects est possible solutions - response times will be optimally short with just one table.
Best regards,
DataNibbler
Yes