$orphan table while using ALIAS

[Anonymous]

While doing INLINE Load, if I use ALIAS keyword to rename a field name, It is getting renamed properly whereas if I use QVD Load and use ALIAS, I am getting one more table named as "$orphan_RenamedField". but field in original table is not getting replaced with new name.

I have following questions:

     1. Am I doing anything in wrong way?

     2. What is that "$orphan_" table?

     3. Why the filed is not getting renamed in the original table itself?

[rubenmarin]

Hi Kushal, I don't know why but doing an optimized load of a qvd and use an alias can turn in that issue. To avoid that use a condition on load:

LOAD ... FROM ... (qvd) Where 1=1;

or load your qvd optimized and then use rename:

RENAME Field OriginalFieldName to NewFieldName;

[marcus_sommer]

Please post your load-script and a screenshot from tableviewer.

- Marcus

[Anonymous]

Hi all,

Please have a look over attached documents.

It consist of script and screenshot of table structure.

[rubenmarin]

Hi Kushal, instead of alias you can set the alias when loading qvd:

LOAD .....

     City as Ceeti

.....

FROM ... (qvd);

or use rename after loading:

LOAD .....

.....

FROM ... (qvd);

RENAME Field City to Ceeti;

[marcus_sommer]

The rename of the fields must be inside the load like:

table:

Load City as Ceeti, * Inline [

....

- Marcus