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

Suppose take my name "Reddyvaraprasad" From source it is coming Reddy vara prasad Need to get As Reddyvara prasad/

4 Answers   TCS,

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

0 Answers   JPMorgan Chase,

---

1)What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

what is a message handler

3 Answers   IBM,

---

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers   TCS,

---

What are system variables and sequencers in datastage

0 Answers  

---

which cache supports connected & un connected Lookup

1 Answers   Wipro,

---

what is data mapping

2 Answers  

---

How to delete the data in dataset?types of deleting the data in dataset?

4 Answers   HSBC,

---

1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?

5 Answers   Gallega, TCS,

---

In my previous project we get data from mainframe and load it into datastage DB2 tables.Sometimes we get data as flat file or a mainframe tables itself directly we fetch the data.Is this a migration project?

1 Answers   TCS,

---

What is apt_config in datastage?

0 Answers  

---