Interested to Buy Any Domain ? << Click Here >> for more details...
Hi, i did what you mentioned in the answer, i.e. source-
>Transformer -> 3 datasets. Iam able to see the data in
datasets but its not sort order... Can you tell how sort
the data?? i also checked Hash partition with performsort.
- 1 Answers
- 5727 Views
- CGI, I also Faced
- E-Mail Answers
Answer Posted / venkatesh
at final it becomefs collecting method in datset.
so we prefer order collection method
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the types of views in datastage director?
What are the main features of datastage?
How you can fix the truncated data error in datastage?
Which algorithm you used for your hashfile?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
Can you explain how could anyone drop the index before loading the data in target in datastage?
What are stage variables, derivations and constants?
What are the repository tables in datastage?
What are the important features of datastage?
What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What is the process of killing a job in datastage?
What is the flow of loading data into fact & dimensional tables?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
