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?
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
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How to manage date conversion in Datastage?
How do you schedule or monitoring the job?
What are the different options associated with dsjob command?
root tree will find which is server job and which is parallel job?
How rejected rows are managed in datastage?
What is the difference between datastage and informatica?
Is it possible to query a hash file?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
how many rows sorted in sort stage by default in server jobs
What are the features of datastage flow designer?
Define Data Stage?
What is the purpose of pivot stage and types of containers in datastage
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is difference between server jobs & parallel jobs?