Answer / Abhishek Bihari

Lookups in SQL Server Integration Services (SSIS) are used to retrieve data from one or more tables, views, or external files and store it temporarily in a DataView object. The purpose of Lookups is to enable conditional execution, data validation, and data transformation within an ETL (Extract, Transform, Load) process.

select sal from emp group by sal

3 Answers   TCS,

---

What is a Mapplet?

1 Answers   Informatica,

---

What information is needed to connect sql*plus an oracle server?

1 Answers  

---

What is before and after trigger?

1 Answers  

---

while loading data into database how can u skip header and footer records in sql*loader

1 Answers   Oracle,

---

i hv 30 rows with date.ex:1month hav 4 weeks i want 1st day of the every week.write the qry for that.example jan has 4 weeks i need 1st dd for evry wk

1 Answers   Aspire,

---

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

1 Answers  

---

How do you select unique values in sql?

1 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

What is mutating sql table?

1 Answers  

---

What is the command used to fetch the first 5 characters of a string?

1 Answers  

---

What is the usage of sql functions?

1 Answers  

---