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
Difference between ‘validated ok’ and ‘compiled’ in data stage?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
Different ways a project can be moved to production ?...example ….export-import and Version control.
sed,awk,head
Which warehouse using in your datawarehouse
Define orabulk and bcp stages?
What are the primary usages of datastage tool?
What is the roundrobin collector?
Is it possible to query a hash file?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What are the components of datastage?
what is ds administrator used for?
How can you write parallel routines in datastage PX?
How you Implemented SCD Type 1 & Type 2 in your project?
What is orabulk stage?