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 can we do null handling in sequential files

2 Answers   Reliance,

---

What is exact difference between Parallel Jobs and server Jobs..

8 Answers   DELL, IBM,

---

what is the use of skid in reporting?

0 Answers   NTT Data,

---

A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

0 Answers   CTS,

---

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,

---

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

---

Explain datastage architecture?

0 Answers  

---

Input file one has data as shown below 1 2 3 4 5 6 7 8 Input file two has data like 6 7 8 9 10 11 Design a data stage job which will provide me three output files as shown below: Output 1 6 7 8 Output 2 1 2 3 4 5 Output 3 9 10 11 Let me know your answers

4 Answers   IBM, PR3 Systems,

---

I want capture UnMatched records from Primary source and secondary source in JOIN stage?

3 Answers   TCS,

---

Where do you see different stages in the designer?

0 Answers  

---

on how many columns we can perform aggregation in the Aggregator stage?

3 Answers   Reliance,

---