Answer Posted / 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 :)

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

781

---

What is orabulk stage?

1048

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2065

---

What a datastage macro?

1064

---

how to write server Routine coding?

2132

---

what is flow of project?

2002

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3167

---

What are stage variables, derivations and constants?

1231

---

Difference between in process and inter process?

1240

---

Differentiate between datastage and informatica?

1186

---

what is use of SDR function?

5176

---

Explain connectivity between datastage with datasources?

983

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

1504

---

What are constraints and derivations?

1171

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1873

---