Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm reading some tables from a SQL Server db and I want to avoid the linking by name between fields with the same name. I have tried to use the NOCONCATENATE for the Load/Select statement before the storing in the QVDs but I can see some synthetic keys and I want to avoid to proliferate them.
Any suggests to me, please? Many thanks
Hi,
Try QUALIFY * before your load instruction. Columns will not have the same name and will not be joined.
Regards,
Vincent
Hi thanks,
but with this statement I rename all fields. I want to allow to join by name for fields with the corrisponding one into a dimension table and to avoid undesirable links. So I have used alias for some fields. However, I haven't reduced the synthetic keys that make unreadable the internal data structure and make hard to solve possible circular references.
Hi,
write this qualify and unqualify statements before your load
qualify *;
unqualify '*_Key';
Name the Keys you want to connect the tables with "_Key" and by this only those keys will be connected
Regards
sravan
Or renaming the attribute field to don't to link as I already made. It is the same. But the problem is also to avoid to do to create synthetic keys and tables not wanted.