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.
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
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
How rejected rows are managed in datastage?
How do you generate sequence number in datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Explain connectivity between datastage with datasources?
How the ipc stage work?
Where do the datastage jobs get stored?
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)
How to implement complex jobs in data stage?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
What is the flow of loading data into fact & dimensional tables?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?
How do u convert the columns to rows in datastage?
What are the types of containers in datastage?
What is the use of hoursfromtime() function in transformer stage in datastage?