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
- 12431 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 is meant by a domain?
If one flat file contains n number of records., we have to load the records in target from 51 to 100.. how to use expressions in Informatica..?
What are the tasks that source qualifier performs?
pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?
Sequence generator, when you move from develoment to production how will you reset
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
Which is the t/r that builts only single cache memory?
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
How do you join more than 3 flat files in informatica?
Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar
how to load first record of first time run,second record to 2nd time n 3rd record from 3rd time to target table
Teradata 
