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 ???????

What is the use of surrogate key stage?

2 Answers  

---

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  

---

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,

---

What is merge stage?

0 Answers  

---

options available in sequence job to run,validate?

0 Answers   CTS,

---

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

---

1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project

1 Answers   Accenture,

---

how to clear the source file? 2) diff b/t odbc & Oracle?what is node? 3) explain one complex job u face in ur project

2 Answers   Wipro,

---

Explain the ChangeApply stage?

11 Answers  

---

Tell me the syntax of Configuration file?

1 Answers  

---

How many areas for files does datastage have?

0 Answers  

---

How to reverse the string using unix?

0 Answers   CTS,

---