Answer / subhash

Another best way is:
SRC--->TFM--->TGT
in TFM, we can do this by using LOOPing concept.
@ITERATION<=100
map the SRC record to TGT.

Answer / ramachandra rao

This Question has two types of answers
1.after source take copy stage after that use funnel stage
and finally use target.copy stage stage allows many output
links after that use funnel stage.and target keep append
mode and u run 100 times 100 records displayed.
2)
u develop the job and kept into sequence with start loop and
end loop.but in in job target has append mode.in loop u give
initial value and increment value and max value.

This is the best answer.

Answer / salendra

By usng pivot stage it can be solved

How do you generate sequence number in datastage?

0 Answers  

---

How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?

2 Answers   TCS,

---

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

0 Answers  

---

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  

---

What is the difference between an operational datastage and a data warehouse?

0 Answers  

---

---

when u face critical situation in ur project, how to solve them?

1 Answers   Toyota,

---

what is the use of materialized view?

0 Answers   CTS,

---

What is Fastly Changing Dimension?

6 Answers   TCS,

---

col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq

9 Answers   Patni,

---

How do u call shellscript/Batch file from DS?

4 Answers   HP,

---

what is a force compile

2 Answers   Cap Gemini, IBM,

---

What is ds designer?

0 Answers  

---