Interested to Buy Any Domain ? << Click Here >> for more details...
country, state 2 tables r there. in table 1 have cid,cname
table2 have sid,sname,cid. i want based on cid which country's
having more than 25 states i want to display?
- 3 Answers
- 8981 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / joe
join these two tables on cid and get all the columns to
output. Then in aggregator stage, count rows with key
collumn cid..Then use filter or transformer to get records
with count> 25
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / manikanta.srinu
select state.cid,country.cname from country inner join
state on country.cid=state.cid group by
state.cid,country.cname having count(state.sname)>25
| Is This Answer Correct ? | 7 Yes | 3 No |
if 3 table having different columes. like first table having 4 columns , second table having 3 columns and third table having 2 columns then how to capture the data by using funnel stage in parallel jobs...srinu.thadi
17 Answers IBM, TCS,
Describe routines in datastage? Enlist various types of routines.
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
What are transforms and what is the differenece between routines and transforms?
What is the process of killing a job in datastage?
In Datastage, how you can fix the truncated data error?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the different plug-ins stages used in your projects?
how to create document in datastage?
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?
I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.
What are the differences between datastage and informatica?
Teradata 
