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 get log info into a file?

1 Answers  

---

eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.

4 Answers   Wipro,

---

What is a quality stage in datastage tool?

0 Answers  

---

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

---

Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,

---

---

1)Source file contains one record, I want 100 records in target file.

3 Answers  

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

0 Answers  

---

Define orabulk and bcp stages?

0 Answers  

---

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

---

what is .dsx files

3 Answers   IBM,

---

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

---

i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer

2 Answers  

---