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
- 34453 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anoymous
override source qualifier
select * from tablename where rownum=1 and rownum=10;
| Is This Answer Correct ? | 4 Yes | 16 No |
star and snowflake schema?
if i am having 10 records in source, i want 20 records in target...how will you do it
how to return multiple columes through through un-connect lookup?
how many new transformations are introduced in 8.1 which are not available in 7.1? any new transformation in 8.6?
Explain reference cursor?
what is fact table?
From where we can start or use pmcmd?
What is informatica? What exactly are the practical uses in real world
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
Roles and Responsibilties of Informatica Production Support Member?
Describe two levels in which update strategy transformation sets?
What is a candidate key?
Teradata 
