Hi Craig, when you put a new activity (such as enrichment ) on design diagram I want to set some options to be enabled ( such as "Disable automatic filtering of 0 ID records" ). Normally is disabled.Is new means simply - new thing in workflow design. Of course when it was unchecked later by user it ...

Hello, I want to set some options in activities to be enabled by default - for ex. "Disable automatic filtering of 0 ID records" to be enabled. I found that I can modify "xtk:workflow" form  (variable @noAutoPkFilter , form label="Advanced parameters" , set value on enter) but how to check if activi...

Hi @Parvesh_Parmar , This is great, For absolutely happiness just I need to make this function work on fluent number of parameters in PARTITION BY section But this approach save a lot of time of compare to computer aggregates separately and joining them with main data set. Thanks a lot  

Hi @CedricRey , but union internally uses joins which are terrible with performance on really large datasets.I need something which can be compared to "UNION ALL" in SQL - no joining data, no grouping.  

Hi, I have problem - to avoid separately computed aggregates calculated on some level and joining them back I want to use windowing functions which are now implemented by many database vendors. I have tried in AC using expression likemax(@eff_dt , PartitionBy(@col1,@col2,@col3))which parses well but...

I'm using Oracle,well, I prefer to convert just those values which are generated by Adobe because the rest of database uses "datetimenotz"  regards

Hi, I have a problem,  We have database DATE fields defined as "datetimenotz" - however when during workflow we are using functions like max() then result is converted to "datetime" Later during steps like intersection we are getting messages about datatypes incompatibility. Is any way to solve that...

Hi, I want to simply combine ALL results from two data streams - Union joins data based on reconciliation set chosen. Speaking in SQL - I want to simply UNION ALL data. regards 

Hi, I wonder how we can change generated SQL statements likeINSERT INTO WKFxxxxxxx (col1,col2.....) SELECT ..........intoINSERT /*+ append */ INTO WKFxxxxxxx (col1,col2.....) SELECT .......... which is in fact bulk insert into table (Oracle database) - and it's greatly reduce redo logs size. Any clu...

Hello All, We are experience issues when WKFXXXXX tables are joined with others. The reason is that optimizer has inaccurate statistics using default settings and chooses wrong join order. In we calculate statistics manually (kill DB process), recalculate statistics using database tools and rerun - ...