Interested to Buy Any Domain ? << Click Here >> for more details...
if a column contains data like
abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc,
roy,pwe,aaa,xxx,xyz,roy,xok....
how to send the unique data to one source and remaining data
to another source????
- 3 Answers
- 8940 Views
- I also Faced
- E-Mail Answers
Answer Posted / s.d sahu
First use aggregator stage use rowcount,then use transformer
rowcount=1 to one source rest to another.
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What is the importance of the exception activity in datastage?
What is the purpose of interprocessor stage in server jobs?
Differentiate between odbc and drs stage?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
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?
Differentiate between operational datastage (ods) and data warehouse?
Why do we use exception activity in Datastage?
Define orabulk and bcp stages?
describe the Steps to confiure a Qlogic switch
Define oconv () and iconv () functions in datastage?
What is process model?
What is usage analysis in datastage?
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?
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
