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 index?how it can work in informatica

0 Answers  

---

write a query to follwoing table amount year quarter 254556 2003 first 546332 2003 second 129034 2003 third 490223 2003 fourth 165768 2004 first 265443 2004 second 510412 2004 third 435690 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 254556 546332 129034 490223 2004 165768 265443 510412 435690

2 Answers   TCS,

---

where does the default group roew in a router is stored what is the default size of memory in router

1 Answers  

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

why u go for dimensions ?

3 Answers   TCS,

---

i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?

6 Answers   Thomson Reuters,

---

what is incremental data aggregation?

3 Answers   IBM,

---

what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram

3 Answers  

---

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

0 Answers   TCS,

---

What is the term PIPELINE in informatica ?

7 Answers   Deloitte,

---

what is unique constraint error ?

2 Answers   TCS,

---