Interested to Buy Any Domain ? << Click Here >> for more details...
in informatica,if i have some no.of records,if i want 1st
and 10th records..what will be the method to use?
- 11 Answers
- 34505 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / pavana
You can use sequence generator and then in exp trn, use a
variable which reads the 1st number the seq generates and
use filter transformation and take only 1st generated row
and +10th record.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Please let me know how to make encryption and decryption with example?
What is confirmed fact in dataware housing?
What is union transformation?
How to create the list file having millions of flat files while indirect loading in informatica? 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 is the commit type if you have a transaction control transformation in the mapping?
how to create user defined function (udf) in informatica
What is a code page?
What is the scenario which compels informatica server to reject files?
What is complex mapping?
Why update strategy and union transformations are active? Explain with examples.
Whats there in global repository
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are connected or unconnected transformations?
