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

Post New Answer

More Data Stage Interview Questions

What are the benefits of datastage?

0 Answers  


What are the some differences between 7.x and 8.x version of datastage?

0 Answers  


what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,


Define project in datastage?

0 Answers  


How we can convert rows to columns in datastage?

4 Answers   IBM,






can we half project in parallel jobs and half project in server jobs?

4 Answers   Infosys, L&T,


difference between server shared container and parallel shared container

6 Answers   CTS,


What is lookup table?

5 Answers  


Thanks to all people who are posting their comments...

1 Answers   CTS,


What is the use of surrogate key stage?

2 Answers  


what is 'reconsideration error' and how can i respond to this error and how to debug this

0 Answers   Wipro,


How a source file is populated?

0 Answers  


Categories