Answer / pavana

You can use sequence generator and then in exp trn, use a
variable which reads the 1st number the seq generates and
use filter transformation and take only 1st generated row
and +10th record.

Answer / jaybrata

have you guys heard of Informatica CUME() function?
Don't use seq generator, aggregator, sq override nothing.

Simply in a expression, calculate,
v_cume = CUME(1)

and after that in a filter use,
v_cume=1 OR v_cume=10

- Jaybrata
(Check www.dwbiconcepts.com)

Answer / prakash kumar kumhar

ower write sq ("select *from <tableNmae> where rownum <= 10;")
than use two aggregation transformation (in first use first(),and in second use last() for each column)from sq to target.
note: use two target table in which u want to load that two records.

Answer / sathish

source may be flat file or database just you use sequence ganarater then filter copy the nextval port to filter write condition nextval=1 or nextval=10 you get only 1 and 10 th records

Answer / prasuna

Ya ..that is right in case its a table..in case of flat
file..i think we cannot use Over ride ...i think using
sequence generator or by finding rownum in Expression
transformation ..after that by filtering two rows ..we get
the output..

Answer / chandrasekhar

You need to use MOD function based on you can filter it
out.. then you will get 1..10..20..30....like we will get it

Answer / chandra

override source qualifier
SELECT E.* FROM(SELECT ENAME,SAL,ROWNUM R FROM EMP) E WHERE
R IN (1,5);
HERE I TAKE EMP TABLE

Answer / eswar

As Prakash said
ower write sq ("select *from <tableNmae> where rownum <=
10;")

Instead of using Aggregator its better if we use Router
Transformation, wherefrom we can route the rows to target
(s).

note: use two target table in which u want to load that two
records
====

Answer / prasuna

sorry,i need here..for example if i have 50 Records..in that
i need 1st and 10th..

Answer / sujana

i think v shud use FIRST and LAST functions in aggregator..

Can we create a node as a gateway node and the same node can be assigned to a grid?

0 Answers  

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

What is a transaction control transformation?

0 Answers   Informatica,

WHat all joins are there in Source Qualifier?

1 Answers  

What are the tuning techniques you applied during your last project

0 Answers  

i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?

1 Answers   Mind Tree,

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

0 Answers  

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com

2 Answers   TCS,

Could any one to tell Fact table Partitioning?

2 Answers  

what is work of PUSH DOWN option

2 Answers   Wipro,