Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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?

Answers were Sorted based on User's Feedback



Hi I am Vijay In my source i've 10 records in a single column.... but i want to split thos..

Answer / parthiban

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

Is This Answer Correct ?    0 Yes 1 No

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split thos..

Answer / aniket

another way is to use select statement ..

Is This Answer Correct ?    0 Yes 1 No

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split thos..

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.

Is This Answer Correct ?    1 Yes 3 No

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split thos..

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

Is This Answer Correct ?    0 Yes 4 No

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split thos..

Answer / bietl

You can use Pivot stage

Is This Answer Correct ?    3 Yes 11 No

Post New Answer

More Data Stage Interview Questions

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,


CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,


sed,awk,head

0 Answers   CTS,


how to export or import the jobs in .ISX file

0 Answers  


What are the components of ascential data stage?

0 Answers  


What are the different options associated with dsjob command?

0 Answers  


I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,


input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2

1 Answers   HCL,


Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  


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

1 Answers   IBM,


What is a delta record? How you will read it?

0 Answers   EDS,


HOW CAN U DO ERROR HANDLING IN DATA STAGE?

8 Answers   ME,


Categories