Difference between 2 files

[cedfoning]

Hello, 

i need some help. 

I have 2 files. 

FileA : 9 000 000 lines

FileA_ID

FileB : 8 000 000 lines. 

FileB_ID

I want to have the ID that in FileA that does'nt exists in FileB

Need your help please

[vamsee]

Try 

FileB:
NoConcatenate
Load 
ID
From FileB;

FileA:
NoConcatenate
Load 
ID
From FileA
Where Not Exists(ID)
;
Drop Table FileB;

[vamsee]

If you want to list all and create a flag try 

FileB:
NoConcatenate
Load 
ID
From FileB;

MapFileA_ID:
Mapping Load 
ID, 'Available in  File A' As Flag
From FileA
Where Not Exists(ID)
;
FileB_Transform:
NoConcatenate
Load
ID, 
Applymap('MapFileA_ID', ID, 'Not Available in File A') as Flag_ID
Resident FileB;
Drop Table FileB;