If a table contains 100 records we have to fetch 50-100
records from source to target?how
- 7 Answers
- 10173 Views
- CSC, I also Faced
- E-Mail Answers
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 |
What are the data movement modes in informatcia?
scd methodology?
what is fact and what types of fact tables is there
Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y
Insert else update option in which situation we will use
explain different levels in pushdown optimization with example?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
Explain in detail scd type 2 through mapping.
What is olap (on-line analytical processing?
How do you use reject loader.
A session S_MAP1 is in Repository A. While running the session error message has displayed
What is sequence generator transformation in informatica?
Teradata 
