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?
IBM,
1 7194if 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?
IBM,
2 7901if 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?
IBM,
1 5567How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
2440Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
2290Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
HCL,
2220A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
TCS,
7 33398
how to write server Routine coding?
What are the various kinds of the hash file?
What is the differentiate between data file and descriptor file?
Describe routines in datastage? Enlist various types of routines.
What is orabulk stage?
Name the different sorting methods in datastage.
sed,awk,head
What are the different types of lookups in datastage?
Give an idea of system variables.
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
Where the datastage stored his repository?
What are the different layers in the information server architecture?
Describe the architecture of datastage?
Difference between server jobs & parallel jobs?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE