Answer Posted / poornachandrababu.l

Hi, This is Poorna,
take a source and then copy stage,to copy stage 2 o/p links
one output is for aggregator and other for join.

In aggregator
set group=deptno
aggregator type=calculation
column for calculation=sal
max value output column=sal.

In Join stage do equee join based on deptno and sal .

And pass output of join Stage to target.
By doing this wasy we can get Max(sal) of the employee on
particular department.

What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

1853

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

1939

---

how to sort two columns in single job in datastage.

2706

---

what is 'reconsideration error' and how can i respond to this error and how to debug this

2326

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3734

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3504

---

EXPLAIN SCD

1144

---

Can you define merge?

837

---

Define data aggregation?

860

---

Define orabulk and bcp stages?

883

---

What is the difference between datastage and informatica?

824

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2117

---

what are the devoleper roles in real time? plz tell i am new to datastage....

1857

---

Describe link sort?

808

---

What are the different common services in datastage?

953

---