Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 9953 Views
- I also Faced
- E-Mail Answers
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
Demonstrate experience in maintaining quality process standards?
What is staging variable?
Where the datastage stored his repository?
What is process model?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What are stage variables?
Explain the situation where you have applied SCD in your project?
what is ds administrator used for?
Whats difference betweeen operational data stage (ods) and data warehouse?
What are transforms and what is the differenece between routines and transforms?
What is orabulk stage?
What are orabulk and bcp stages?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
what are the errors,warnings in datastage
