Scenario 3: Importing data from a CSV file to Neo4j and creating relationships using
a single Cypher query
This scenario applies only to a Talend solution with Big Data.
This scenario describes a Job that imports family information from a CSV file into a
remote Neo4j database and create relationships between persons and families using a
single Cypher query through a tNeo4jRow component.
Below is content of the CSV file to import data from in this
example:
example:
|
1 2 3 4 5 6 7 |
Name;Gender;Age;Family Jenny;Female;24;the Johnsons Jack;Male;26;the Johnsons Richard;Male;35;the Blacks Anne;Female;36;the Whites Helen;Female;28;the Blacks Tom;Male;38;the Whites |
As MERGE is used with LOAD CSV in this example, to ensure
the Cypher query is executed in an efficient way, another tNeo4jRow component is used to create an index on the property to
merge.
Document get from Talend https://help.talend.com
Thank you for watching.
Subscribe
Login
0 Comments