What is fact table? Explain the different kinds of facts.

603

---

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

574

---

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

683

---

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

1488

---

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

563

---

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

611

---

Briefly explain input and put function?

615

---

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

628

---

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

664

---

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

558

---

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

798

---

Mention few capabilities of sas framework.

680

---

What are the parameters of scan function?

607

---

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

565

---

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

822

---