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

.prm wirh repalce .txt is possible?

2 Answers  

From where we can start or use pmcmd?

3 Answers  

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

Define Pmrep command?

0 Answers  

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

How do you handle two sessions in Informatica

0 Answers   Informatica,

Without using any transformations how u can load the data into target?

15 Answers   IBM,

we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?

1 Answers   Polaris,

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai

1 Answers   Infosys, Saksoft,