I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
3 5071what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
3 9038suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
9 10741while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
1 4330lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
5 6901differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
2 5238performance wise which one is better in joiner and lookup transformation?why?explain clearly?
1 4532every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
1 4435performance wise which one is better in joiner and lookup transformation?why?explain clearly?
4 19760There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
7 10571Post New IBM Informatica Interview Questions
Consignment matl how will be use
What element does the symbol au stand for?
Which instrument is used for measuring high temperatures?
can i get hindi version of is codes based on civil engineering?
Do you know what are the purpose of washing?
how to calculate short circuit current for the busbar
On which interface you will be working as a developer?
Explain the type of clustering in R?
Ho can you re-render a component without using setState() function?
What cycle most directly describes the working cycle of a heat engine operating as an ideal engine of maximum thermal efficiency?
What are the advantages that you can get from mainframe connect in sybase?
What is Apex in Salesforce?
What is session storage and how can you create one?
Which are sixteen bit registers of 8085?
What is cascadetype in hibernate annotations?