on how many columns we can perform aggregation in the
Aggregator stage?
Answer Posted / kiran
Depends upon Requirement....u can apply aggregations
| Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Can you explain engine tier in information server?
Difference between sequential file and data set?
How to reverse the string using SQL?
Which algorithm you used for your hashfile?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What is the purpose of pivot stage and types of containers in datastage
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
DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks
What is the difference between odbc and drs stage?
what is the difference between == and eq in UNIX shell scripting?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the areas of application?
What are the types of views in datastage director?
What is difference between join, merge and lookup stage?