on 11-13-2018 5:12 PM
I'm trying to build audit table and I need to have dataflow name in my audit table. I have used dataflow_name function in order to fetch dataflow name. But, the problem is i'm writing this script outside the dataflow and hence its not fetching any value.
Can someone suggest me what function I can use to get dataflow name or how can I populate dataflow name in the table?
This is not a problem, but standard behaviour :-). From the SAP Data Services Reference Guide:
"
Returns the data flow name in which this call exists. If the call is not in a data flow, returns NULL.
"
To populate tour audit table, embed a Row_Generation - Query - (Audit) Target Table stream in your data flow(s). Use the function in the Query transform mapping.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.