Help on Partial Load

[priyarane]

Hi Community,

Can some one help one partial for the below example.

Out of thre only one table will effect each run.

Table1:
LOAD * INLINE [
Key1, Value1
abc, 200
def, 234
];



Table2:
LOAD * Inline [
Key1, Value1
D, 100
E, 200
F, 200
];



Table3:
LOAD * INLINE [
Key1, Value1
G, 100
H, 200
I, 100
];

_priya

[Anil_Babu_Samineni]

May be use NoConcatenate for each to bifurcate in data model.

[priyarane]

synthetickeys will form

[prma7799]

What are you looking for please share expected output...

[avinashelite]

for the table with gets effected each time add the Ky word Add only e.g. if the table 3 has to get the latest data then

Table1:
LOAD * INLINE [
Key1, Value1
abc, 200
def, 234
];



Table2:
LOAD * Inline [
Key1, Value1
D, 100
E, 200
F, 200
];



Table3:

ADD only
LOAD * INLINE [
Key1, Value1
G, 100
H, 200
I, 100
];

[Anil_Babu_Samineni]

NoConcatenate Load prefix will concatenate all fields and produce lot Synthetic keys.

You can use a QUALIFY * to fully qualify the field names (but that's similar to RENAME the fields).

Can we know the use case to rid separate the tables.

Another way i come up with using Flag

Load *, 'T1' as Flag From T1;

Load *, 'T2' as Flag From T2;

Load *, 'T3' as Flag From T3;

[avinashelite]

how is this concept related to Partial reload ??? bit confused what problem we are trying to solve 

[Anil_Babu_Samineni]

Don't confuse, Title may not same as Body message. Here, The concept is related to bifurcate 3 tables even we have same schema from 3 tables. That is what her intend and it prevent to bright the glow of vision.

[priyarane]

How data will update for our example there are 3 tables

Table1:
LOAD * INLINE [
Key1, Value1
abc, 200
def, 234
];

Table2:
LOAD * Inline [
Key1, Value1
D, 100
E, 200
F, 200
];

Table3:
LOAD * INLINE [
Key1, Value1
G, 100
H, 200
I, 100
];

Now may be possiblity table one only will be update

LOAD * INLINE [

Key1, Value1

zzz, 288

ddde, 782

];

so now only table one update and other two table should be there

[avinashelite]

You mean the complete data in the table 1 will change or new records will come to table 1 ??