how can we load starting with 11th record of a table from
source to target
Answers were Sorted based on User's Feedback
Answer / akash
This scenario can also be implemented by using the
following query in Source Qualifier:
select * from table_name where rowid not in (select rowid
from table_name where rownum <= 10)
This will give the records after 10
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / ajit
use sequence generator with port key to source rows and then
use filter condition key>11
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / prabhu
If it a flat file u can use initial no of rows to skip
property while creating source definition.We can set it to
11 so that informatica will skip 11 rows while reading from
source
Prabhu
www.iskilltech.com
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / murali gundeti
use sequence generator with port key to source rows and then
use filter condition key>10
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / krish
take expression in exp take variable port(v1.......v1+1)and
take output port(in that give v1)send this o/p port to
router give the condition as v1>11.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
it is not possible to take data from 11th records. because
consider this senario.. if u give select statement as
select column name1,2.... from table name where rownum<5;
this select statement wil work if u have 10 or more than 5
records in table.
now u r asking to load only from 11th record
so the query will be like this
select column name1,2,.... from table name where rownum>10;
it wil return emptyset only..
see the checking condition. it wil fetch the 1st record and
check rownum 1 > rownum 10. condition failed. so it wont go
to second record and results in empty set.
but in earlier case it wil fetch 1st record and checks
rownum 1 < rownum 5. condition satisfied. it wil load that
row and check for 2nd row and 3rd and so on until the
condition fails.
once the condition fails it wil come out.
Is This Answer Correct ? | 1 Yes | 10 No |
How can you recover the session in sequential batches?
What is the difference b/w natural key and surrogate key
Could any one to tell Fact table Partitioning?
what is the logic will you implement to load data into a fact table from n dimension tables?
What are Rapid changing dimensions?
what is the difference between static and dynamic
Can we override a native sql query within informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
what is lookup chache?
Is it possible to revert a global repository to local one and why?
what is procedure to use mapping variable in source qualifier transformation? with example
rank() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid order by case when opt2.dm_market_flg in ('Y', 'U') then 1 else 2 end, lkp.contact_rank) as rank1, case opt2.contact_type when 'Buyer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, ship_to_flg desc , last_order_dt desc) when 'Decision Maker' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc , last_quote_dt desc , mailability_score desc , source_ranking desc) when 'Influencer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) when 'Payer' then row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) --elu 05/28/2013 else row_number() over (partition by opt2.dim_plat_site_id, opt2.dim_site_opt_sid, lkp.contact_rank order by has_name_flg desc, mailability_score desc, source_ranking desc) end rank2 row_number() over (partition by opt3.dim_plat_site_id, opt3.dim_site_opt_sid order by rank1,rank2) as "rank", case when "rank"<= opt3.maximum_value then 'Y' else 'N' end as include_flg