how do u reduce warnings
In order to reduce the warnings you need to get clear idea
about particular warning, if you get any idea on code or
design side you fix it, other wise goto director-->select warning and right click and add rule to message, then click
ok. from next run onward you shouldn't find any warnings.
Is This Answer Correct ? | 9 Yes | 2 No |
there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
What are the benefits of datastage?
What are operators in datastage?
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.
Differentiate between Join, Merge and Lookup stage?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
What are the various kinds of the hash file?
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?
how to find no.of records in sequntial file itself?
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?