Thanks a lot for showing great interest and helping me in needed times. Your further suggestions will be highly appreciated regarding above explained scenario. In Neo4j, since there is no table schema or equivalent to restrict possible properties, non-existence and null are equivalent for node and relationship. If required, I can share the table details and joining conditions to plan it much better and can have a further discussion on it via call / skype meeting but It is totally subjected to your interest in this. Good thing is we have some joining conditions in each table with other. Hence, for 5 different tables we have total 100 columns / properties. SITE TABLE, CONTAINER TABLE, SHELF TABLE, CARD TABLE, PORT TABLE and all these tables having near about 20 columns each. And Telecom inventory has few major data tables like I will look for 1st suggestion by implementing technically in my neo4j system.įor second suggestion, I am 100% agree with you but unfortunately we are using neo4j to dump the Telecom inventory in it. I am very happy and thankful to you as you are helping me out to move in correct direction with your suggestions. RETURN 'loading MDB Data', MDB.CIRCUIT_ID

MDB.NEO4J_EPOC_MODIFIED_DATE=timestamp()) MDB.SCNDRY_PARENT_IP_ADDRESS=row.SCNDRY_PARENT_IP_ADDRESS, MDB.SCNDRY_PARENT_HOST_NAME=row.SCNDRY_PARENT_HOST_NAME, MDB.SECONDARY_PARENT=row.SECONDARY_PARENT, MDB.LAST_MILE_ACCESSED=row.LAST_MILE_ACCESSED, MDB.SAR_IPV4_ADDRESS=row.SAR_IPV4_ADDRESS, MDB.AG2_IPV4_ADDRESS=row.AG2_IPV4_ADDRESS, MDB.AG1_IPV4_ADDRESS=row.AG1_IPV4_ADDRESS, MDB.CSS_IPV4_ADDRESS=row.CSS_IPV4_ADDRESS, MDB.ECR_IPV4_ADDRESS=row.ECR_IPV4_ADDRESS, MDB.EDS_IPV4_ADDRESS=row.EDS_IPV4_ADDRESS, MDB.L2_SWITCH_SAP_ID=row.L2_SWITCH_SAP_ID, MDB.L2_SWITCH_IP_ADDRESS=row.L2_SWITCH_IP_ADDRESS, MDB.L2_SWITCH_HOST_NAME=row.L2_SWITCH_HOST_NAME, MDB.RSRVD_IP_ADDRESS=row.RSRVD_IP_ADDRESS, R4G_STATE from STG.STG_ENTERPRISE_MDB_NEO4J_DTLS ') YIELD row To_char(MODIFIED_DATE, 'DD-MM-YYYY') AS BI_MODIFIED_DATE,

To_char(created_date, 'DD-MM-YYYY') AS BI_CREATED_DATE, Let me know how can we make this query more fast and simple. Below is my Query created with the help of you guys.

Neo4j allow null in result