Answer Posted / saran

Output1:
eid,ename
11,AA
11,CC
11,BB
22,DD
22,BB
22,AA
22,CC
33,EE

Output2:(stable)
eid,ename
11,AA
11,CC
11,BB
22,DD
22,AA
22,BB
22,CC
33,EE

Output3:(unique
eid,ename
11,AA
22,DD
33,EE

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2167

---

What are stage variables and constants?

1134

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

2880

---

Define data aggregation?

1083

---

What is difference between symmetric multiprocessing and massive parallel processing?

1124

---

Why do we use link partitioner and link collector in datastage?

1115

---

What are the different options associated with dsjob command?

1417

---

Distinguish between informatica & datastage. Which one would you choose and why?

993

---

Which algorithm you used for your hashfile?

1166

---

I have a few records just I want to store data in to targets cycling way how?

2341

---

how many rows sorted in sort stage by default in server jobs

3984

---

Define oconv () and iconv () functions in datastage?

1395

---

How do you run datastage job from the command line?

1075

---

how to implement scd2 in datastage 7.5 with lookup stage

5592

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

922

---