Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7036 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
How to perform incremental load in datastage?
Triggers,VIEW,Procedures
How many types of stage?
why do u need the IOS upgradation in a FC switch
What is the difference between the local container and shared container?
Where do the datastage jobs get stored?
What is use Array size in datastage
what is the use of skid in reporting?
Why do you need stage variables?
What is the difference between server job and parallel jobs?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
If you want to use a same piece of code in different jobs, how will you achieve this?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
How to read multiple files using a single datastage job if files have the same metadata?
What are stage variables and constants?
