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
- 34480 Views
- L&T, I also Faced
- E-Mail Answers
Answer Posted / jaybrata
have you guys heard of Informatica CUME() function?
Don't use seq generator, aggregator, sq override nothing.
Simply in a expression, calculate,
v_cume = CUME(1)
and after that in a filter use,
v_cume=1 OR v_cume=10
- Jaybrata
(Check www.dwbiconcepts.com)
| Is This Answer Correct ? | 14 Yes | 3 No |
Post New Answer View All Answers
What is workflow? What are the components of the workflow manager?
What is deployment group?
What is sq transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a pre-defined event and user-defined event?
Explain the mapping variable usage example in informatica
What is the sequence generator transformation in informatica?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
How many numbers of sessions can one group in batches?
If informatica has its scheduler why using third party scheduler?
What is powercenter on grid?
