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?
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
Can you filter data in hashed file?
How you can fix the truncated data error in datastage?
How many Key we can define in remove duplicate stage?
Notification Activity
Which commands are used to import and export the datastage jobs?
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
How a source file is populated?
What is a merge?
To see hidden files in LINIX?
What are the different type of jobs in datastage?
Differentiate between operational datastage (ods) and data warehouse?
Difference between data warehousing and olap?
What is a folder? Difference types of stages?
Define Merge?
Define Job control?