Abintio Record Format- Setting NULL to variable
It is the default setting for your INPUT. There is nothing wrong with it. When component A will send the information to B it will behave just fine, as far as I'm concerned. Look at this example from my grpah that I'm working right now: string(30) salesperson = NULL(""); When...
Ab initio component to stop the graph if duplicate rows/records found
etl,talend,data-manipulation,ab-initio
Pass the flow to dedup component. In Dedup component, select unique property for output. This will give you all the unique records. Now in case you have duplicate records, it will go thru the dup port. You can collect those record(s) in a intermediate file (for auditing purpose) and the...
“m_db unload” command not returning any value in AbInitio
parameters,etl,graphical-programming,ab-initio
I have found a solution for this problem. There were two mistakes I was doing: First I was not committing the data after insertion in SQL server. Second I was using parameter interpretation as substitution but now I have changed it to shell. Any other suggestion are most welcomed. :)...