Interested to Buy Any Domain ? << Click Here >> for more details...
i hav source like this .
deptno,sal
1,2000
2,3000
3,4000
1,2300
4,5000
5,1100
i want target like this
target1
1,2000
3,4000
4,5000
target2
2,3000
1,2300
5,1100 with out using transformer
- 2 Answers
- 7459 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / hari chowdary
by using partition technique round rabin we can do easily.
single source table,two target tables
| Is This Answer Correct ? | 16 Yes | 1 No |
____tgt1
|
|
source------transformer---
|
|
-----tgt2
in transformer
TGT1 ---
constraint --> mod(deptno,2) = 1
source.deptno - deptno
source.sal - sal
TGT2 ---
constraint --> mod(deptno,2) = 0
derivation -->
source.deptno - deptno
source.sal - sal
u'll get the ans, if i'm wrong plz correct me
| Is This Answer Correct ? | 6 Yes | 11 No |
Differentiate between datastage and informatica?
What are the stages in datastage?
what is the function in Transformer stage can act as Rank function in Oracle
2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?
Define meta stage?
How many types of views are there in a datastage director?
i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance
Unix command to view the data in a dataset
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
Teradata 
