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
- 5656 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 |
What are the different layers in the information server architecture?
How many areas for files does datastage have?
Wat is pre-load in Hashed file
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)
can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
why we use hash file for lookup?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
where we use config file as parameter ?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Teradata 
