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

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

0 Answers  

have u done any performance tuning? how u ll do?

0 Answers   IMB, TCS,

In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?

2 Answers  

What are the tasks that source qualifier perform?

0 Answers   Informatica,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

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

0 Answers  

what is the method of error handling when session is running?

1 Answers   TCS,

What is the difference between Oracle performance and Informatica Percfomance? Which performance is better?

4 Answers   Cap Gemini, IBM,

In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.

2 Answers   TCS,

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

Explain the different dimensions.

0 Answers  

how to connect two or more table with single source qualifier?

4 Answers   IBM,