If a table contains 100 records we have to fetch 50-100 records from source to

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

If a table contains 100 records we have to fetch 50-100
records from source to target?how

Question Posted / guest

7 Answers
12767 Views
CSC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

If a table contains 100 records we have to fetch 50-100 records from source to target?how..

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

If a table contains 100 records we have to fetch 50-100 records from source to target?how..

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

If a table contains 100 records we have to fetch 50-100 records from source to target?how..

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

If a table contains 100 records we have to fetch 50-100 records from source to target?how..

Answer / vikash sharma

SELECT * FROM Tab_name
WHERE Record BETWEEN 50 AND 100;

Is This Answer Correct ?

0 Yes

0 No

If a table contains 100 records we have to fetch 50-100 records from source to target?how..

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

If a table contains 100 records we have to fetch 50-100 records from source to target?how..

Answer / rajesh

use condition rownum>=50 in filter transformation

Is This Answer Correct ?

2 Yes

5 No

If a table contains 100 records we have to fetch 50-100 records from source to target?how..

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

Post New Answer