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

Define orabulk and bcp stages?

1124

---

Can you explain kafka connector?

1312

---

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

2453

---

What is process model?

1984

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2024

---

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

781

---

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

1078

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

4044

---

how to write server Routine coding?

2132

---

How do you start developing a datastage project?

1112

---

how to add a new records into source?

2000

---

how to delete one row in target dataset

3123

---

What are some different alternative commands associated with "dsjob"?

1169

---

Can you explain tagbatch restructure operator?

1184

---

options available in sequence job to run,validate?

1323

---