Answer Posted / venugopal

Take source in the sequential file and take two copy stages
and map the columns to two copy stages and use funnel stage
to funnel the data from two copy stages and o/p into the
file now you can see the o/p is your requirement....

Hope this will help you...

What all the types of jobs you developed?

1115

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2166

---

What are the primary usages of datastage tool?

1017

---

Different ways a project can be moved to production ?...example ….export-import and Version control.

2387

---

how do u catch bad rows from OCI stage? And what CLI stands for?

2749

---

Differentiate between datastage and informatica?

1140

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1684

---

What is meta stage?

1131

---

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

2406

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

952

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1029

---

If you want to use a same piece of code in different jobs, how will you achieve this?

1224

---

How one source columns or rows to be loaded in to two different tables?

1071

---

1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2043

---

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

2176

---