Answer / chandrasekar

DISTINCT is used to display the unique records.

Answer / sudhakar

it will shown single time.
ex:-in accounts dept have 10 employees.
naturally
employee dept
sai acccouts
sudhakar accounts
ramesh accounts
etc.... upto 10members

like distinct show
department show single time
Employee Dept
10 accounts

Answer / amol m

Distinct keyword is used to eliminate duplicate records and
showing only single one.

Answer / alok

SELECT distinct * FROM STUDENT;

what is data driven?

1 Answers  

---

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  

---

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

---

How to update or delete the rows in a target, which do not have key fields?

0 Answers   Informatica,

---

What is a taget load order?

2 Answers   IBM,

---

If u r using dynamic cache lookup port will be thier in thet which option u will select

1 Answers   HCL,

---

When do you use mapping parameters? (In which transformations)

1 Answers  

---

What do you understand by term role-playing dimension?

0 Answers  

---

What is a data modeling?

2 Answers  

---

I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?

1 Answers   IBM,

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

What is a unit Testing?

1 Answers  

---