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
- 13985 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 sequential file and data set?
To see hidden files in LINIX?
Which warehouse using in your datawarehouse
What are transforms and what is the differenece between routines and transforms?
What are the types of containers?
Define data aggregation?
What is data partitioning?
Difference between data warehousing and olap?
How many areas for files does datastage have?
Does datastage support slowly changing dimensions ?
How many types of hash files are there?
Define Data Stage?
What are some prerequisites for datastage?
What are datastage sequences?
What is staging variable?
