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

Describe link sort?

992

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2232

---

What are routines in datastage? Enlist various types of routines.

1081

---

Why do we use link partitioner and link collector in datastage?

1111

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2466

---

What are stage variables?

1186

---

Differentiate between data file and descriptor file?

1026

---

Define meta stage?

1183

---

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

992

---

How do you run datastage job from the command line?

1071

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

918

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1490

---

Differentiate between Join, Merge and Lookup stage?

1073

---

What are the different type of jobs in datastage?

1033

---

what is flow of project?

1978

---