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
- 13425 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
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
options available in sequence job to run,validate?
How can you write parallel routines in datastage PX?
What are the processing stages?
What are the steps needed to create a simple basic datastage job?
Define project in datastage?
How to reverse the string using SQL?
What are the differences between datastage and informatica?
What a datastage macro?
What are routines in datastage?
What steps should be taken to improve Datastage jobs?
What is a folder? Difference types of stages?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
Describe routines in datastage? Enlist various types of routines.
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
