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?
2227Different ways a project can be moved to production ?...example ….export-import and Version control.
2439if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
5 10695if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
3 8982i want job aborted after some records are loaded into output by using only sequential stage and dataset
IBM,
1 6461iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..
4 8417HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
FIS,
5 10974
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 ?
Define data aggregation?
how to implement scd2 in datastage 7.5 with lookup stage
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
What is the use of datastage director?
how to export or import the jobs in .ISX file
What are iconv and oconv?
What is meta stage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How the ipc stage work?
why do u need the IOS upgradation in a FC switch
What are system variables and sequencers in datastage
What are the types of jobs we have in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
Describe link sort?