Interested to Buy Any Domain ? << Click Here >> for more details...
i/p o/p1 o/p2
1 1 4
1 1 5
1 1 6
2 2
2 2
2 2
3
3
4
5
6
how to populates i/p rows into o/p1&o/p2 using datastage
stages?and also the same scenario using sql?
- 8 Answers
- 13764 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rvanaja.etldeveloper@gmail.com
just read the data in sequential file
and take aggregator
group=cid
aggregation type=count rows
count output column=countno
then take filter from filter you drag 2 links for two outputs
in filter write conditions like bellow and give link order
where clause=countno>1
and
where clause=countno=1
map in output links
seqfile-->aggregator-->filter-->2 torgets
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Difference between server jobs & parallel jobs?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are the functionalities of link partitioner and link collector?
what is 'reconsideration error' and how can i respond to this error and how to debug this
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
table actions available in oracle connector?
Can you define merge?
Differentiate between odbc and drs stage?
What all the types of jobs you developed?
Explain datastage architecture?
How do you reject records in a transformer?
What is the difference between datastage and informatica?
What is merge stage?
Differentiate between data file and descriptor file?
What can we do with datastage director?
