When creating a new map for a client, this needs to be done first – create a client feed or map a client feed
What is create a client feed?
100
When you need to know the command/function to concatenate the contents of two variables together.
What is Go to the Help Screen in Express>IT and search for “concat”? Or, use string_concat?
100
Looks like the sun and moon colliding
What is the Profiler Icon?
200
string_substring(common_mapping.MEMBER_ID, 9, 1)
What is the '9' and '1' should be inverted?
200
How do I replace characters in a string?
What is string_replace?
200
The two process types that are available when creating a client feed.
What are Update and Refresh?
200
When you have created a map for a new client and need to implement it in production.
What is coordinate the implementation with the Onboarding COE Team?
200
This tab shows you views of your data like "AAA-AAAA" or "999-999-9999".
What is the "Default Patterns" tab?
300
if (lrtrim(ADDRESS1) == "") "N/A"
What is it should be 'string_lrtrim'?
300
Combines two strings together
What is string_concat?
300
This function can be used to remove extra spaces from the beginning and end of a data field.
What is lrtrim?
300
When you are unable to log into Express>IT due to userid/password issues (i.e. you forgot your password and your account has been locked).
What is since the userid that is used to access Express>IT is a UNIX id, submit a Service Now ticket to the “IT UNIX System Admin” group?
300
Click this to find special characters in your system?
What is "Observable Characters"?
400
string_concat(ABC, 123)
What is you need to put quotation marks around the values?
400
Apply this logic. Or, if a condition is true, apply another set of logic.
What is an 'if' statement?
400
The two main components of a business rule.
What are the trigger and the output?
400
When you experience a technical issue with the Express>IT tool.
What is open a Service Now ticket to the “Business Intelligence Systems” team. (Members of the Ab Inito COE are in this group.)? Also send an e-mail to the Onboarding COE team in case it is a common error and they are able to assist.
400
This technique will allow you to profile your output data.
What is running it against the Test data?
500
if (Type == "E") groupid else groupid_d
What is nothing at all?
500
Gets the first three characters of "ABCDEF".
What is string_substring("ABCDEF", 1, 3)?
500
Name at least 4 of the load record format versions that are available when setting up a client feed.
What are 2.4, 2.6, 4.0, 6.0, 6.1, 7.1, 8.0, and 8.1?
500
When you need to create a specialized function in Ab Initio to retrieve segmented data.
What is submit an e-mail request to the Onboarding COE Team?
500
This pattern, 99999-9999, as the predominant pattern in my 'City' field tells me this.
What is the client has most likely mapped the zip code to the anticipated city field?