What are the functionalities of link collector?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
What is data partitioning?
what is the main difference between sorragate key n primary key in one word
What are the different options associated with dsjob command?
can we see the data in fixed width file? how can u change the datatype of fixed width files?
How to read multiple files using a single datastage job if files have the same metadata?
What are the areas of application?
What are transforms and what is the differenece between routines and transforms?
how can we create tables in datastage?
How do you get log info into a 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.
if 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?