Hi I have scenario like this s/r table T/r table ename,sal empno,ename,sal vijay,2000 1 , vijay, 2000 kumar,3000 2 ,kumar , 3000 ravi ,4000 3 ,ravi , 4000 How can i get target table like that without using Transformer stage?
8 13525How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
1 12445How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
TCS,
5 12549hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
CTS,
6 17516Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 33544in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
IBM,
2356in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
IBM,
1 8706In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
IBM,
1 12168
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Which algorithm you used for your hashfile?
What is the difference between hashfile and sequential file?
Is the value of staging variable stored temporarily or permanently?
If you want to use the same piece of code in different jobs, how will you achieve it?
which r the connectors used in san?
What is the difference between an operational datastage and a data warehouse?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
What is the difference between orabulk and bcp stages?
Enlist various types of routines in datastage.
What is the difference between datastage and informatica?
What are the types of containers in datastage?
project Steps,hits, Project level HArd things,Solved methods?
If you want to use a same piece of code in different jobs, how will you achieve this?
How a server job can be converted to a parallel job?