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
- 10189 Views
- I also Faced
- E-Mail Answers
Answer Posted / thippareddy.p
From source copy the data into sets using copy or peak
stage then for each copy stage use remove duplicate stage
with duplicate to retain first and last you will get
desired output.....
Hope thios will help u.......
| Is This Answer Correct ? | 1 Yes | 16 No |
Post New Answer View All Answers
Different ways a project can be moved to production ?...example ….export-import and Version control.
I have a few records just I want to store data in to targets cycling way how?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
How do u convert the columns to rows in datastage?
What is the precedence of stage variables,derivations, and constraints?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what are the errors,warnings in datastage
Define repository tables in datastage?
Differentiate between validated and Compiled in the Datastage?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is ibm datastage flow designer?
What are the differences between datastage and informatica?
Can you explain kafka connector?
What are the different common services in datastage?
What is oci?
