Answer / parthiban

if u used the sorting pgogram it will sort the variables in
a 4th

Answer / aniket

another way is to use select statement ..

Answer / 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.

Answer / pakkya

declare stage variable in transformer, increment variable
with every row read. have 5 outputs from transformer with
constraint to write rows 1,2...3,4...5,6...7,8...9,10

Answer / bietl

You can use Pivot stage

I have 2 jobs.I want to ru job B if job A has run 3 times.How can I achieve this through datastage

3 Answers   IBM,

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers   Wipro,

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

0 Answers   IBM,

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,

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,

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers   Wipro,

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,

My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?

2 Answers   Wipro,