former_member186897
Contributor
Member since ‎07-06-2013

User Statistics

  • 244 Posts
  • 20 Solutions
  • 17 Kudos given
  • 226 Kudos received

User Activity

Query Transform Bug in Data Services

02-15-2018
Hello All, Does anyone aware if Data Services 4.2.9 has a bug where it does not show From tab in Query transform? See the screen shot below. I don't know how we can perform outer joins in absence of this? Please let me know if anyone aware ab...

Implementing Join Ranks in Data Services

11-28-2016
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 join rank had significantly improved the performan...

​How to use Custom SQL in Lookup_Ext Function?

01-28-2015
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 can use this feature in Lookup_Ext function which is less known a...

Selecting distinct records from a view

07-29-2014
Hi All,I am wondering how IS does not provide a distinct option when we create a view. Also, it restrict to keep all fields as output column whatever you are using in the joining. Do you know how to take distinct records in data insight without using...

How to get the total number of records in a view?

07-29-2014
Hi All,Does anyone aware how to get the total number of records in a view in Data Insight? I have observed that when we view data from the physical table it gives the total number of records but same is not available when viewing the data using a cus...
View more