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
- 12751 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 |
Please let me know how to make encryption and decryption with example?
i have flatfile source. i want to load the maximum salary of each deptno into target. what isthe mapping flow
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
How we will implement Pushdown Optimization and Types in Informatica with better examples
Write the program through which the records can be updated?
WHAT IS FACT TABLES?
What are the out put files that the informatica server creates during the session running?
server hot-ws270 is connect to Repository B. What does it mean?
Can yoU use the maping parameters or variables created in one maping into another maping?
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
Teradata 
