What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
2159what is push and pull technique??? I want to two seq files using push technique import in my desktop what i will do????
TCS,
1 7300cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
TCS,
3 8365Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.
IBM,
1 4375Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?
IBM,
7 13359Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.
CGI,
1 5817i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
IBM,
2 14434I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
CGI,
1 5772Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?
TCS,
3 18843
Difference between in process and inter process?
root tree will find which is server job and which is parallel job?
Define Routines and their types?
What are datastage sequences?
What is the purpose of pivot stage?
How can we improve the performance in datastage?
Can you explain repository tables in datastage?
Can we use target hash file as a lookup ?
What are stage variables?
Name the different types of Lookups in Datastage?
CHANGE CAPTURE
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 is the roundrobin collector?
What are the components of ascential data stage?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees