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
- 13671 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
What is datastage engine?
What is oci?
What is the differentiate between data file and descriptor file?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
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
On which Dimension Table you implemented SCD Type in your Project
How can you write parallel routines in datastage PX?
Explain the importance of surrogate key in data warehousing?
What is the difference between odbc and drs stage?
Can we use target hash file as a lookup ?
What are stage variables, derivations and constants?
What is the process of killing a job in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
