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

What are the repository tables in datastage?

0 Answers  

what is mapping lookup

1 Answers  

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

Nls stands for what in datastage?

0 Answers  

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

What are constraints and derivations?

0 Answers  

I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????

5 Answers  

Tell me the syntax of Configuration file?

1 Answers  

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

0 Answers   HCL,

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  

Can you implement SCD2 using join, transformer and funnel stage?

0 Answers   Cognizant,