Interested to Buy Any Domain ? << Click Here >> for more details...
If a table contains 100 records we have to fetch 50-100
records from source to target?how
- 7 Answers
- 12262 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 |
Explain sql transformation in script mode examples in informatica
How to do unit testing in informatica?
What is data caches/ index caches?
Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?
have you developed documents in your project? and what documents we develop in realtime?
How do you set a varible in incremental aggregation
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
Dependecy Errors in Informatica ? Do u got any dependency problems while running session? Can any one Explain Clearly.
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2. what is the procedure and whar t/r's are involved and what is the mapping flow
what is procedure to use mapping variable in source qualifier transformation? with example
What are the rank caches?
Teradata 
