Data loading issues from Data model

[kvr9]

Hi ,

I tired to load below data into my data model and it is loaded successfully, but when I tired to load it using binary load Was not able to fetch the completed association between the tables.

Table A:

Load Country,

State,

Division,

Revenue,

Profits

From table A;

Concatinate(Table A)

Table B:

Load

Rowno() as% table,

Country,

State,

Division,

Spends

From table B;

Join(Table c)

Table C

Load

Rowno() as% table1,

Country,

Sales

From Table c;

I used link table to relate all three tables.It loaded and association is perfect

but after loading using binary load into my application,the third table missing its association .sometimes after reload few countries getting associated.

Could someone help me how to solve this issue.

[felipedl]

Hi Vijaya,

I've done a sample test with the following:

[Table A]:

Load * Inline

[

Country,State,Division,Revenue,Profits

a,a1,a11,1,1

a,a2,a11,43,2

a,a1,a12,4,56

a,a1,a15,1,1

b,b2,a1,1,1

];

NoConcatenate

[Table B]:

Load * Inline

[

Country,State,Division,Spends

c,c1,c11,1

d,d2,d11,43

e,e1,e12,4

f,f1,f15,1

g,g2,g1,1

];

NoConcatenate

[Table C]:

Load * Inline

[

Country,State,Division,Sales

i,i1,a11,1

i,i2,a11,43

j,j1,a12,4

j,j1,a15,1

k,k2,a1,1

];

NoConcatenate

LinkTable:

Load

RowNo() as %tableA

// Country,

// State,

// Division,

// Revenue,

// Profits

Resident [Table A];

Concatenate(LinkTable)

Load

  RowNo() as %tableB

//  Country,

//  State,

//  Division,

//  Spends

Resident [Table B];

Join(LinkTable)

Load

  RowNo() as %tableA,

  RowNo() as %tableC

//  Country,

//  Sales

Resident [Table C];

Qualify *;

UNQUALIFY %tableA;

DataTableA:

Load

RowNo() as %tableA,

*

Resident [Table A];

UNQUALIFY %tableB;

DataTableB:

Load

RowNo() as %tableB,

*

Resident [Table B];

UNQUALIFY %tableC;

DataTableC:

Load

RowNo() as %tableC,

*

Resident [Table C];

drop tables [Table A],[Table B],[Table C];

That gives me the following data model

And the binary load gives the complete data model.

What I believe its happening is that the tables are being automatically concatenated, due to having the same field names.

Felipe.

[kvr9]

Hi Feilp,

Thank you,

it worked partially for me,all columns are related except one column from 3rd table after Binary load.

Since the data is confidentially I cant share the snapshot of it.

Request you to help in resolving the issue

[felipedl]

Hi Vijaya,

can you share a snapshot of the Data Model (CTRL+T in View) with the fields that are being connected?

Filter the other ones in paint or so, with a figure on top, just so I can see whats happening on the binary load.

Felipe.

[kvr9]

Hi Feilp,

Apologies for delay in response.

The issue is D_count table is not associated  and it is created by concatenating in transform layer .Should I use join in place of concatenate in transform layer?

Also can you please advise me which is preferable to join the tables Join/Concatenate my data contain same column names only one fact need to link with 1^st table

[felipedl]

Hi VIjaya,

If the data makes sense the way your looking at it, just stay with it.

Otherwise, if you only have, let's say only %BaseNo and D_Count are used in the concatenation, use a separate table for it.

Hope it helps, i didnt understand fully what you meant on your post to be honest.

Felipe.