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
- 5390 Views
- CGI, I also Faced
- E-Mail Answers
Answer / venkatesh
at final it becomefs collecting method in datset.
so we prefer order collection method
| Is This Answer Correct ? | 1 Yes | 0 No |
1)What is ur project architecture ? 2)how to move project from developement to uat? 3)What is the difference between datastage 6,7.1 and datasttage 7.5? 4).How to do error handling in datastage? 5)3.Whta is unit testing, system testing and integration testing? 6)What is the Exact difference between BASIC Transformer and NORMAL Transformer?When we will go for BASIC Or NORMAL Transformer 7)why we use third party tools in datastage? 8)What is the purpose of Debugging stages? In real time Where we will use?
6 Answers CTS, HCL, IBM, Wipro,
which cache supports connected & un connected Lookup
Can you explain tagbatch restructure operator?
How can we achive parallelism
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
How to implement complex jobs in data stage?
What are the types of containers in datastage?
Wat is isolation level and when do u use them?
Why fact table is in normal form?
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)
Teradata 
