if i have two tables
table1 table2
1a 1a,b,c,d
1b 2a,b,c,d,e
1c
1d
2a
2b
2c
2d
2e
how can i get data as same as in tables?chandu
how can i implement scd typ1 and type2 in both server and in parallel?chandu
field1 field2 field3
suresh , 10,324 , 355 , 1234
ram , 23,456 , 450 , 456
balu ,40,346,23 , 275, 5678
how to remove the ,inthe fields?
- 2 Answers
- 6460 Views
- I also Faced
- E-Mail Answers
Answer Posted / murari
By using the sort stage we can remove the duplicates by setting the option ALLOW DUPLICATES=FALSE......
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Define orabulk and bcp stages?
What are system variables and sequencers in datastage
Nls stands for what in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Difference between server jobs & parallel jobs?
Describe the architecture of datastage?
What is the difference between Datastage 7.5 and 7.0?
What is the difference between datastage and informatica?
How to clean the datastage repository?
How do you register plug-ins?
CHANGE CAPTURE
Is it possible to query a hash file?
What are stage variables, derivations and constants?
Describe the main features of datastage?
what is use of SDR function?
