If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
where we cannot use sorter Transformation. if we use then we will not get correct data?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
how to change the execute of macro
what is user variable in affinium campaign? and some real time examples.
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
in u r data u having duplicates how to fetch the latest data in our report?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
tell me 5 session failure in real time how can you solve that in your project?
explain about unit testing? in real time?
wf dont have integration severances how you can run?