Oracle supports hierarchies in data via the connect_by http://psoug.org/reference/connectby.html construct. Vertica does not have this functionality in the base release but there is an extension in github https://github.com/vertica/Vertica-Extension-Packages/tree/master/compatlib_functions that mimi...

Where do you want to write it to? Thinking outside the box, you could use the hadoop connector or you could use a custom UDX.

Would love to talk with you about this - contact me at joe@vertica.com and I can fill you in on everything I know before you talk with a sales guy

Vertica can scale to large numbers of nodes with K=1 or K=2. The "K" number is not about total nodes but about fault tolerance of contiguous nodes and shadow copies of data. Is there a reason you would want to run with K>2?

Another option is to use the ExternalSource UDL from github. You can then use whatever command line interface you want for converting the XML.

I would look at INSERT to see if it fits your needs.

http://my.vertica.com/docs/6.0.1/HTML/i ... #16048.htm

Can I ask what you have for the commit level in Informatica? I believe the default is 10k rows.