If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answers were Sorted based on User's Feedback
Answer / nitin
Use a sequence generator Transformation to filter the
records from 50 to 100 and then load to Target.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / tauseef
hai Tauseef,
as per my knowledge we can Fetch 50-100 records
by using rownum>=50 in source qualifier it self after generation sql query
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / udit
If the question is like they want to load next half record then we write query in source qualifier
select * from table
minus
Select * from table
where rownum<=(select count(*)/2 from table)
this query will load the next half i.e. from 50 to 100 records
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vikash sharma
SELECT * FROM Tab_name
WHERE Record BETWEEN 50 AND 100;
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajesh
in rownum not support grater than so use in filter
transformation iif(rownum<50,false,true)
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / rajesh
use condition rownum>=50 in filter transformation
Is This Answer Correct ? | 2 Yes | 5 No |
Answer / imran
use a Sequence Generator T/R........
GO to SG T/r-->Properties (Set the values as shown below)--->
1) 'Enable' the Cycle Option
2) give 'Start value' as 50
3)End Vale 100
4) Increment BY 1
5) Connect Nextval & Currval o/p ports to Target
Is This Answer Correct ? | 1 Yes | 4 No |
hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.
How to Migrate the UNIX SCRIPTS from SIT TO PROD?
What are the methods for creating reusable transforamtions?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
How can u work with remote database in informatica?did you work directly by using remote connections?
how can i invoke pmcmd in command line prompt
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
what is index?how it can work in informatica
sorce is a flatfile only 1st and last row should insert to target how will u do?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
what is the difference between repository & Intergration service
what are the difference between Informatica 7.1 and 8.1?