Answer / 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

Answer / npr

IS it DWH question ???????

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

---

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

0 Answers   HCL,

---

table actions available in oracle connector?

0 Answers   CTS,

---

can a fact table contains textual information

6 Answers   HCL, HCL BSERV, IBM,

---

types of errors in datastage?

2 Answers   Reliance,

---

What all the types of jobs you developed?

0 Answers  

---

What are the different plug-ins stages used in your projects?

0 Answers  

---

What are the steps required to kill the job in Datastage?

0 Answers  

---

what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?

12 Answers   Wipro,

---

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

---

how to configure databases through datastage

2 Answers  

---