input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?

2 Answers   HSBC,

---

what is snow flack schema?

2 Answers  

---

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

---

What is the difference between an operational datastage and a data warehouse?

0 Answers  

---

What are the different database update actions available?

1 Answers   HP,

---

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

---

how to implement scd2 in datastage 7.5 with lookup stage

0 Answers   TCS,

---

Which algorithm you used for your hashfile?

0 Answers  

---

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

difference between server shared container and parallel shared container

6 Answers   CTS,

---