Answer Posted / suneel

Hi Praveen Kumar yenduri,

can u explain deeply, why u using TX, join and stored procedures in this job.
what is the need of these stages.. please explain me.

Thanks.

What are the differences between datastage and informatica?

570

---

What is oci?

855

---

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?

1745

---

what is the use of surogate key in datastage

1822

---

What are the different common services in datastage?

705

---

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1467

---

How and where you used hash file?

659

---

What all are the different way to run a job?

642

---

why do u need the IOS upgradation in a FC switch

1875

---

What are the functionalities of link partitioner?

618

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

349

---

How many types of hash files are there?

611

---

How can we improve the performance in datastage?

654

---

How many areas for files does datastage have?

642

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

674

---