Enlist various types of routines in datastage.
No Answer is Posted For this Question
Be the First to Post Answer
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
What is lookup table?
What is difference between server jobs & parallel jobs?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
DataStage Scenario based Interview Questions
Difference between in process and inter process?
Two source files contains same meta data third file contains different data types can I funnel that file.
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
What are stage variables and constants?
Scenario : I have 2 jobs say job A and Job B with parameters x and y respectively. I need to create a sequence job. If we pass parameter x then Job A should run, If we pass parameter y then Job B should run, if we dont pass any parameter then Both Job A & B should run.
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What are the types of jobs we have in datastage?