Interested to Buy Any Domain ? << Click Here >> for more details...
how will you get 21 to 30 record from 50 records?
- 6 Answers
- 11786 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srikanth
select * from table where rownum<=30
minus
select * from table where rownum<=21;
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / nilesh
Other than the above ans:
Using sequence generator, expression and filter
transformation
OR
Using mapping variable initialised to zero, expression and
filter transformation.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / rkumar.etl
if you want to process using unix/linux...we can use head
and tail logic to get the records from 21 to 30.
and in informatica we can use rank transformation twice to
get the required results.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / koti
sq generator, filter transformations. write the condition
in filter transformation as select columns from table where
sno>21 and sno<30...
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / giri
Very simple
Using sequent generator then Filter transformation
| Is This Answer Correct ? | 1 Yes | 2 No |
sir presently i am persuing my m.tech recently i got job in tcs as fresher presently iam doing my 9 months project related to informatica can any one guide me how to create fact tables what type of schemas must be used and so on if so give ur mail ids so that i can contct through it
How can yoU improve session performance in aggregator transformation?
how can u avoid duplicate rows in flat file?
Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...
1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),
How to load only the first and last record of a flat file into the target?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
How many repositories can we create in Informatica?
How can i maintain unique surrogate key if 2 seperate workflows from different repository run and insert/update the main table at the same time.
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
Name the different lookup cache(s)?
Teradata 
