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?
how can i implement scd typ1 and type2 in both server and
in parallel?
field1 field2 field3
suresh , 10,324 , 355 , 1234
ram , 23,456 , 450 , 456
balu ,40,346,23 , 275, 5678
how to remove the duplicate rows,inthe fields?
No Answer is Posted For this Question
Be the First to Post Answer
What is orabulk stage?
1.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
how can u connect the client system directly at any time?
root tree will find which is server job and which is parallel job?
What are stage variables, derivations and constants?
If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
how to implement scd2 in datastage 7.5 with lookup stage
HOW CAN WE ABORT THE JOB IF THE RECORDS OF SOURCE FILE CONTAINS VALUE AS 'VIJAY'?
Where the datastage stored his repository?
In which situations we can use normal and sparse lookup stages
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance