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 :)

options available in sequence job to run,validate?

832

---

Have you used Unstructured data?

830

---

what are the errors,warnings in datastage

2145

---

create a job that splits the data in the Jobs.txt file into four output files. You will direct the data to the different output files using constraints. • Job name: JobLevels • Source file: Jobs.txt • Target file 1: LowLevelJobs.txt − min_lvl between 0 and 25 inclusive. − Same column types and headings as Jobs.txt. − Include column names in the first line of the output file. − Job description column should be preceded by the string “Job Title:” and embedded within square brackets. For example, if the job description is “Designer”, the derived value is: “Job Title: [Designer]”. • Target file 2: MidLevelJobs.txt − min_lvl between 26 and 100 inclusive. − Same format and derivations as Target file 1. • Target file 3: HighLevelJobs.txt − min_lvl between 101 and 500 inclusive. − Same format and derivations as Target file 1. • Rejects file: JobRejects.txt − min_lvl is out of range, i.e., below 0 or above 500. − This file has only two columns: job_id and reject_desc. − reject_desc is a variable-length text field, maximum length 100. It should contain a string of the form: “Level out of range: ”, where is the value in the min_lvl field. My Question is how do you write the stage variable for reject rows.

2187

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2270

---

---

How one source columns or rows to be loaded in to two different tables?

656

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2027

---

What are the different types of lookups in datastage?

626

---

project Steps,hits, Project level HArd things,Solved methods?

1623

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1927

---

Could anyone give brief explanation bout datastage admin

1965

---

how to implement scd2 in datastage 7.5 with lookup stage

5127

---

What is the difference between Datastage 7.5 and 7.0?

671

---

How to RD using transformer?

857

---

What are the types of containers and how to create them?

556

---