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..

How can we get multiple output values using an unconnected lookup transformation?

2 Answers   TCS,

What is meant by incremental aggregation?

0 Answers  

Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

0 Answers  

how to we create datamart?

2 Answers   HSBC,

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

0 Answers   CTS,

How can you complete unrcoverable sessions?

1 Answers  

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

what is normalizer transformation?

4 Answers   Wipro,

what is confirmed fact?

2 Answers  

How we can create indexes after completing the load process?

0 Answers