Hi This is Vijay, How can your remove the duplicates in sequential File?15 21350
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 8644
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?1 10041
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha
Hi 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 23582
in job of 30 one job is very slow due to this entire job is very slow how can u know which job is slow?
in 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?
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
How many types of views are there in a datastage director?
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What are the difference types of stages?
Name the third party tools that can be used in datastage?
What is the difference between Datastage 7.5 and 7.0?
What are some prerequisites for datastage?
What is the difference between an operational datastage and a data warehouse?
What is the purpose of interprocessor stage in server jobs?
What are the steps needed to create a simple basic datastage job?
How can we improve performance of data stage jobs?
Difference between data warehousing and olap?
What is meta stage?
Define Routines and their types?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
what is the use of skid in reporting?