how to change left and right links in join stage?
Answer Posted / katru prasad
By changing the Link orders in the Join stage.
Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
How complex jobs are implemented in datstage to improve performance?
What is quality stage?
What is the flow of loading data into fact & dimensional tables?
Give an idea of system variables.
Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.
Have you used Unstructured data?
Where do the datastage jobs get stored?
To see hidden files in LINIX?
Which commands are used to import and export the datastage jobs?
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
What are routines in datastage? Enlist various types of routines.
Define oconv () and iconv () functions in datastage?
in oracle target stage when we use load option and when we use upsert option?
What are the job parameters?
Describe link sort?