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 ?
No Answer is Posted For this Question
Be the First to Post Answer
i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
how many dimentions and fact tables used in your project and what are names of it?
what is the main difference between sorragate key n primary key in one word
How many Key we can define in remove duplicate stage?
Can aggregator and transformer stages use to sort the data? How ?
If you want to use a same piece of code in different jobs, how will you achieve this?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
30 jobs are running in unix.i want to find out my job.how to do this?Give me command?
What are the components of ascential data stage?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
how to convert rows into columns