how to get the first row without using rank t/r?
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 |
write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24
What is limitations of truncate and load option
can v update d records in target using update stargey without generationg primary key ? explain
How can we use batches?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Hi, Can someone send me the DWH and Informatica FAQ's at priti.singh84@gmail.com Thanks in Advance, preeti
What is sq transformation?
hi, as al you know, we can set the option in session level as all rows treat as like insert,update etc., And also we have update strategy for flaging records as insert,update etc.. then when we will go for above options and what is the difference.. explain..
What are mapping parametres and variables in informatica?
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
Can we make worklet inside worklet?