Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12902 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / moorthy g
In Source Qualifier Sql Override
Ex: Table Name: Dept1
SELECT DEPT1.DEPTNO, DEPT1.DNAME, DEPT1.LOC
FROM
DEPT1
WHERE ROWNUM=1
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / abhishek kumar
step 1
if first row h as not null then we can use first()
function in aggregator T/F.
step 2
use sequence generator T/F And filter T/F write condition
nextval=1
| Is This Answer Correct ? | 10 Yes | 0 No |
by using first function in aggregator transformation.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / basi
your question is worng . because you are asking fist row
why are you using rank t/r
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / balakrishna
select empno,name,deptno,loc from emp where rownum=1
and
first using sorter select asc,create expression t/r using the variable v_count=v_count+1,o_count=v_count after using the filter t/r to write condition o_count=1 connect filter t/r to target
and
source--->sq--->seq--->exp--->filter--->target
and
select * from emp where rownum=1minusselect * from emp where rownum=2
| Is This Answer Correct ? | 0 Yes | 0 No |
what is dimension table?
How do you update the records with or without using update strategy?
i have 1000 record flat file source i want 1st row to 1st target, 2nd row to 2nd target, 3rd row to 3rd target how will u do? Without using Mod Function? Explain....
what is lookup ?
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
What is informatica worklet?
If I have router with 10 records, if the condition doesn’t satisfy the records will pass to the default group,then where can we see that records and where that records will store?
What do you mean incremental aggregation?
Differences between connected and unconnected lookup?
How do you promote a non-reusable transformation to reusable transformation?
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
Teradata 
