Answer / chemistrya2z

select * from <tbl> where rownum<2;

Answer / anil

use first function in agg or seq->filter(rounum=1) then
connect to target .i am right or wrong?

Answer / srinivasarao dasari

Hi Chandra,

You did not mention the criteria that how do u want that
first record should be fetched.

Answer / somnath pain

I suppose u r working with informatica.
So here u can import the source and after the source use a
expression transformation.
use a sq generator set start val to 1.
connect the nextval port to expession transformation.
apply a filter and set filter condition as nextval=1 connect
the filter o/p to target.
u will get the desired row.

regards,
Somnath

Answer / bsgsr

simple. connect the source to ranker select top and set no
of ranks to 1.

Answer / narsi

If it is flat file use sed command

Answer / amedela chandra sekhar

Select * from(select rownum as rno,emp.* from emp) where rno=&n
EX:

SQL> Select * from(select rownum as rno,emp.* from emp) where rno=&n;
Enter value for n: 1
old 1: Select * from(select rownum as rno,emp.* from emp) where rno=&n
new 1: Select * from(select rownum as rno,emp.* from emp) where rno=1

RNO EMPNO ENAME JOB MGR HIREDATE SAL
---------- ---------- ---------- --------- ---------- --------- ----------
COMM DEPTNO
---------- ----------
1 7369 SMITH CLERK 7902 17-DEC-80 800
20

Answer / subramanyam

use rank transformation u can get it

Answer / hanumantharao

select *from emp where rownum=1;

Answer / rv

select @ from <tbl> where rownum>2; im right ?
other wise mail to me rayallarv@gamil.com

Explain lookup transformation in informatica

0 Answers   Informatica,

How to delete the data in the target table after loaded.

3 Answers   TCS,

What are the phases in SDLC?

3 Answers  

what happens when a batch fails?

3 Answers  

What are ETL Tools?

0 Answers   Informatica,

How do you load unique records into one target table and duplicate records into a different target table?

0 Answers  

How u use pdf file in informatica source?

2 Answers   Ericsson, HP, IBM,

i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow

3 Answers   Wipro,

how to get flatfile containg 10 records half records one target another half another target

2 Answers  

hi all when i am creating repository contents i am getting this error and not able to create contents please let me know wht may be the problem ORA-01031: insufficient privileges Database driver error... Function Name : executeDirect SQL Stmt : CREATE VIEW REP_DATABASE_DEFS AS SELECT DISTINCT DBDNAM DATABASE_NAME, SRCNAM DEF_SOURCE, SUBJ_NAME SUBJECT_AREA, NULL VERSION_ID, OPB_DBD.VERSION_NUMBER DATABASE_VERSION_NUMBER FROM OPB_DBD, OPB_SUBJECT, OPB_SRC WHERE OPB_DBD.SUBJ_ID = OPB_SUBJECT.SUBJ_ID AND OPB_SRC.DBDID = OPB_DBD.DBDID AND OPB_SRC.VERSION_NUMBER = OPB_DBD.VERSION_NUMBER AND OPB_SRC.IS_VISIBLE = 1 Oracle Fatal Error Database driver error... Function Name : ExecuteDirect Oracle Fatal Error Error occurred while creating the repository An error has occurred while creating contents. Dropping repository tables... Create Contents operation on repository [reposerv] ended at 01/02/2009 13:02:48. Elapsed time is 0:00:09.

2 Answers  

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

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

0 Answers   SeeInfoBiz, TCS,