i have source like
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100
i want target like
target1
deptno,sal
1,2000
3,4000
4,5000
target2
2,3000
1,2300
5,1100
with out using transformerstage
Answer Posted / naveen
seq1---------seq2
seq1 read the file.
seq2 ----give outfile1 and click on file give outfile2 then partition tab then select roun rabin partition key first column.
get the desired output.
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
What is the process of killing a job in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the important features of datastage?
Define oconv () and iconv () functions in datastage?
What is the roundrobin collector?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Can you explain how could anyone drop the index before loading the data in target in datastage?
How and where you used hash file?
What are transforms and what is the differenece between routines and transforms?
How do you schedule or monitoring the job?
How to manage date conversion in Datastage?
What is a datastage job?
What is the different type of jobs in datastage?
What is aggtorec restructure operator?