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;

how to return multiple columes through through un-connect lookup?

1 Answers   DELL,

---

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

---

What is rank transformation?

0 Answers  

---

WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.

2 Answers  

---

how can we load 365 flat file to a single fact table (target) as a history load in single mapping?

2 Answers  

---

Explain the aggregator transformation?

0 Answers  

---

what is SDLC way of code development?

0 Answers  

---

any body can say about all versions of informatica ?how many versions ?

2 Answers  

---

What is the use of transformation?

0 Answers  

---

Enlist the advantages of informatica.

0 Answers  

---

Plz can any one say me how to get the informatica certification materials and dumps

0 Answers   TCS,

---

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

---