How to read multiple files using a single datastage job if files have the same metadata?
No Answer is Posted For this Question
Be the First to Post Answer
HOW CAN WE SEE THE DATA IN DATASET?
12 Answers IBM, TCS,
what is .dsx files
How can we run same job in 1 day 2 times
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
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.
1) In a dataset how to delete a single row? 2) i have 50 rows , i want to display 5-7 records only? How to write the sql query? 3)i have 40 rows,i want to display last row? write sql query?
What are routines in datastage?
types of errors in datastage?
How many nodes supported by a one cpu in parallel jobs?
What steps should be taken to improve Datastage jobs?
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
What is lookup table?