Menu
  • HOME
  • TAGS

“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. :)...

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...

Abintio Record Format- Setting NULL to variable

ab-initio

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...