Answer / subhash

1. SRC---->TFM---->TGT
in the TFM, by using Looping we, can do this.
@ITERATION<=5

2.SRC---->COPY===>(5copies/links)==>FUNNEL---TGT

take 5 output links from copy stage, pass those to Funnel
then you will get the desired output.

3. SRC--->TGT
run the job 5 time in 'APPEND' mode

Answer / venki

Hi



source ->copy- funnel -target


here copy the out put link to funner 5 times it will work

Answer / ankit gosain

Hi All,

Well you can create a job with O/P file in Append mode,
like:

I/P Seq file----->O/P Seq file

and use it under a Sequence Activity with Start Loop and
End loop activity like.

Start Loop---->Sequence1---->End Loop
| |
|-------------------------|

Start Loop properties:
---------------------
From=1
to=5
Spet=inc

In this way the job will be executed for the 5 times and
you will get the desired O/P.

Cheers,
Ankit :)

Answer / shailesh

simplest solution that i can think of using ds8.1 pivot satge
seqfile--->pivot--->target

in pivot stage give the derivation for new_col as old_col,old_col,old_col,old_col,old_col (five times)
map it to target you will get the desired output

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

---

How do you register plug-ins?

0 Answers  

---

WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?

2 Answers   Wipro,

---

How can u write exception handling in seq file????

2 Answers   IBM,

---

---

What are the types of containers in datastage?

0 Answers  

---

How did you reconcile source with target?

3 Answers   HP,

---

How do u set a default value to a column if the column value is NULL?

7 Answers   HP,

---

what are the different type of errors in datastage?

2 Answers   Wipro,

---

Triggers,VIEW,Procedures

0 Answers   CTS,

---

whats relation between configuration file and datasets?

2 Answers   L&T, Wipro,

---

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

---