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
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
In which situations we can use normal and sparse lookup stages
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What modeling tool do you use?
How do you find the number of rows in a sequential file?
in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5
What is the difference between orabulk and bcp stages?
What is active and passive stage?
how can u handle null values in transformer stage.
how do u catch bad rows from OCI stage? And what CLI stands for?
Unix command to view the data in a dataset