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
- 5742 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 |
Please tell me What is difference between 8.0 and 8.1
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.
what is combinability and non combinability?
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?
how to configure databases through datastage
What are data elements?
What is a merge in datastage?
what is the function in Transformer stage can act as Rank function in Oracle
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
What is use Array size in datastage
I have source like "abcdefghijklmnopqrs", how to change 10th character from j to z in datastage?
Teradata 
