if we using two sources having same meta data and how to
check the data in two sources
is same or not? and if the data is not same i want to abort
the job ?how we can do this?
No Answer is Posted For this Question
Be the First to Post Answer
What could be a data source system?
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.
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
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 the important features of datastage?
What are the different layers in the information server architecture?
What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?
How do u set a default value to a column if the column value is NULL?
How do you get log info into a file?
How can remove duplicates in a file using UNIX?
Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??
How will you move hashed file from one location to another location?