U CAN TAKE COPY STAGE AND TAKE 5 SEQ.FILES AS A TARGETS. IN COPY STAGE U C

Hi I am Vijay
In my source i've 10 records in a single column.... but i
want to split those records into 5 sequential files each
seq file contains 2 records.?.... can any body help me?

Question Posted / harsha

15 Answers
32867 Views
Scope International, I also Faced
E-Mail Answers

Answer Posted / harsha

U CAN TAKE COPY STAGE AND TAKE 5 SEQ.FILES AS A TARGETS.
IN COPY STAGE U CAN DRAG 2 RECORDS INTO EACH TARGET LINK.
THEN U GET EACH TARGET 2 RECORDS.

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between validated and compiled in the datastage?

1188

How to manage date conversion in Datastage?

1068

Distinguish between informatica & datastage. Which one would you choose and why?

952

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1366

Explain datastage architecture?

1332

Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?

2163

Define APT_CONFIG in Datastage?

1017

How to read multiple files using a single datastage job if files have the same metadata?

1174

Name the third party tools that can be used in datastage?

1020

How many types of views are there in a datastage director?

1231

Explain connectivity between datastage with datasources?

938

What are routines in datastage?

1264

What is job control?

1032

Explain how a source file is populated?

1310

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.

2671