Un-Answered Questions { Data Warehouse }

How many ways are there to do 'remove duplicate records in informatica'?

583


How to join three sources using joiner? Explain though mapping flow.

693


How do you load only null records into target? Explain through mapping flow.

1495


I have a dataset concat having variable a b & c. How to rename a b to e & f?

574


How do you specify the number of iterations and specific condition within a single do loop?

615


Briefly explain input and put function?

621


Give some examples where proc report’s defaults are same as proc print’s defaults?

637


What is the length assigned to the target variable by the scan function?

668


What is the difference between one to one merge and match merge? Give an example.

565


List down the reasons for choosing sas over other data analytics tools.

803


Mention few capabilities of sas framework.

687


What are the parameters of scan function?

615


What are the differences between sum function and using “+” operator?

574


Given an unsorted data set, how to read the last observation to a new data set?

832


How do you delete duplicate observations in sas?

571