Answer Posted / msbharathi

- > Unique
Sq File - > Aggregate - > Transformer |
- > Duplicate

1. Read data in seq file stage.
2. In Aggregate stage group by EID and count the number of rows in Count column
3. In transformer stage create loop condition as @ITERATION<= DSLink6.Count and derivation as EID = EMPNO.
4. In unique output tab use constraint count<=1 and in duplicate output tab use constraint count>1

what is the custome stage in datastage? how can we impliment that one? plz tell me

2362

---

How do you reject records in a transformer?

1117

---

Differentiate between Join, Merge and Lookup stage?

1088

---

which r the connectors used in san?

2179

---

Which algorithm you used for your hashfile?

1174

---

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?

2170

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2855

---

What are datastage sequences?

1116

---

What is active and passive stage?

1407

---

describe the Steps to confiure a Qlogic switch

2380

---

How do u convert the columns to rows in datastage?

1183

---

What are the functionalities of link partitioner?

1012

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1495

---

what is the difference between == and eq in UNIX shell scripting?

1494

---

What is difference between server jobs & parallel jobs?

1030

---