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
- 34876 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
Differentiate between reusable transformation and mapplet.
tell me 5 session failure in real time how can you solve that in your project?
What is a sorter transformation?
What are ETL Tools?
Slowly changing dimensions, types and where will you use them
Write the unconnected lookup syntax and how to return more than one column.
wf dont have integration severances how you can run?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
design of staging area?
How to elaborate tracing level?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Explain target update override in informatica
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is flashback table ? Advance thanks
