This article is a continuation of my previous article which can be accessed here. Below is a real case scenario where I implemented the Join rank recently for one of my data migration project. Using
I recently saw people asking how to use Custom SQL in Lookup_Ext. I searched for it online but could not find much written on this subject. So this article will explain in short how we
Hello Everyone, Last week I was searching for how to export Users and Groups in IS but unfortunately could not found the answer and then created a thread where one of the member answered that.
What is substitution parameter? Substitution parameters are used to store constant values and defined at repository level. Substitution parameters are accessible to all jobs in a repository. Substitution parameters are useful when you want to
Getting function name from a datastore could be useful if you have configured more than one datastores in your project. This helps avoiding code change while migrating objects from one environment to another during the
The simplest way of fetching table statistics would be reading the stats from repository Metadata table. This information could be used while building the framework for a Job in DS and could be helpful in
Below is step by step procedure to write a custom function in BODS to remove special characters in a string using ASCII values. Step 1: Create a custom function in BODS and name it as
I will be walking you through (step by step procedure) how we can capture error messages if any dataflow fails in a Job. I have taken a simple example with few columns to demonstrate. Step
What is Join Rank? You can use join rank to control the order in which sources (tables or files) are joined in a dataflow. The highest ranked source is accessed first to construct the join.