what is the difference between datasatge and datastage TX?6 21467
Is possible to create skid in dim,fact tables?
table actions available in oracle connector?
root tree will find which is server job and which is parallel job?
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?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
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?
How you Implemented SCD Type 1 & Type 2 in your project?
How to reverse the string using unix?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
What is process model?
why do u need the IOS upgradation in a FC switch
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
what are the devoleper roles in real time? plz tell i am new to datastage....
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?