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
Answer / parthiban
if u used the sorting pgogram it will sort the variables in
a 4th
| Is This Answer Correct ? | 0 Yes | 1 No |
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 |
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 |
diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
sed,awk,head
how to export or import the jobs in .ISX file
What are the components of ascential data stage?
What are the different options associated with dsjob command?
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 ?
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
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are the third party tools you used in your project?
What is a delta record? How you will read it?
HOW CAN U DO ERROR HANDLING IN DATA STAGE?