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

create a mapping to retrieve the employees who are getting salary greater than average salary?

4 Answers   TCS,

while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?

1 Answers   IBM,

Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V

3 Answers   NTT Data,

What are batches?

0 Answers  

difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,

what is the difference between static and dynamic

4 Answers   TCS, Wipro,

When the informatica server marks that a batch is failed?

1 Answers  

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

Quickly characterize reusable change?

0 Answers  

What is the status code in stored procedure transformation?

0 Answers   Informatica,

write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,