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?
IBM,
2182Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.
6 130101.how to generate even numbers in surrogate or tranformar stage ? 2. how many ways to remove duplicate values?
5 15135i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?
1 6019
Define ds designer?
What are the differences between datastage and informatica?
How you Implemented SCD Type 1 & Type 2 in your project?
What are the components of ascential data stage?
What are the functionalities of link partitioner and link collector?
How can you write parallel routines in datastage PX?
What is process model?
Which commands are used to import and export the datastage jobs?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What is the difference between an operational datastage and a data warehouse?
what is the use of skid in reporting?
What is the difference between server job and parallel jobs?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
Explain the importance of surrogate key in data warehousing?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)