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

which dim, fact tables used in bank domain

1 Answers   HSBC, IBM,

How to read multiple files at different directories using a single Sequential File stage in DS Enterprise Edition

6 Answers   TCS,

What are the third party tools you used in your project?

1 Answers   IBM,

Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

How did you reconcile source with target?

2 Answers   HP,

what is parameterset?

4 Answers   Wipro,

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

Is it possible to query a hash file?

0 Answers   IBM,

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

0 Answers  

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,