Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
UHG,
3748there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities
2 7241
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What are routines in datastage? Enlist various types of routines.
Explain datastage architecture?
options available in sequence job to run,validate?
Define ds designer?
What is apt_config in datastage?
What are the types of containers?
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?
What is data partitioning?
Differentiate between hash file and sequential file?
What are the different type of jobs in datastage?
Define oconv () and iconv () functions in datastage?
How do you generate sequence number in datastage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What are the steps needed to create a simple basic datastage job?
