Answer Posted / bharath

Instead of transformation use Combination in datastage,

Horizontal combining:
> join
> look-up
> merge
Vertical combining:
> remove duplicates
> Aggregation
Diagonal Combining:(not sure)
> vertical pivoting
> Horizontal Pivoting

Have you used Unstructured data?

1321

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5123

---

What are the repository tables in datastage?

1309

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2463

---

What are stage variables, derivations and constants?

1228

---

What is apt_config in datastage?

1140

---

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?

2179

---

How and where you used hash file?

1175

---

What is the difference between server job and parallel jobs?

1156

---

What is difference between symmetric multiprocessing and massive parallel processing?

1144

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2505

---

What is "fatal error/rdbms code 3996" error?

1268

---

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

1010

---

Can anyone tell me a difficult situation who have handled while creating Datastage jobs?

3250

---

Differentiate between datastage and informatica?

1182

---