How many ways are there to do 'remove duplicate records in informatica'?
How to join three sources using joiner? Explain though mapping flow.
How do you load only null records into target? Explain through mapping flow.
I have a dataset concat having variable a b & c. How to rename a b to e & f?
How do you specify the number of iterations and specific condition within a single do loop?
Briefly explain input and put function?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What is the length assigned to the target variable by the scan function?
What is the difference between one to one merge and match merge? Give an example.
List down the reasons for choosing sas over other data analytics tools.
Mention few capabilities of sas framework.
What are the parameters of scan function?
What are the differences between sum function and using “+” operator?
Given an unsorted data set, how to read the last observation to a new data set?
How do you delete duplicate observations in sas?