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
- 8845 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
How you can fix the truncated data error in datastage?
Which commands are used to import and export the datastage jobs?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
How many areas for files does datastage have?
How do you start developing a datastage project?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
How do you schedule or monitoring the job?
What are the components of datastage?
Differentiate between Join, Merge and Lookup stage?
What is orabulk stage?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Name the third party tools that can be used in datastage?
what are the errors,warnings in datastage
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
