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

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?

3 Answers   Polaris,

What are the tasks that can be performed using sq?

0 Answers  

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

0 Answers  

how to run 2 workflows sequentially. plz respond what is the process?

9 Answers   Cap Gemini, Target,

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

explain different types of modeling.

2 Answers  

Source-1 No name 1 satish 2 karthik 3 swathi 4 keerthi Source-2 No name 1 satish 2 karthik 5 santhose 6 vasu Target 3 swathi 4 keerthi 5 santhose 6 vasu here i want non matching Records i want how to achieve that

5 Answers   TCS,

What is informatica etl tool?

0 Answers  

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  

I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,