Using NOCONCATENATE

[#1]

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

[vincent_ardiet]

Hi,

Try QUALIFY * before your load instruction. Columns will not have the same name and will not be joined.

Regards,

Vincent

[#3]

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.

[#4]

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

[#5]

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.