In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / boss
How can you say which is thir record when all the salaries
are same...
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Difference between Target-based loading and constraint-based loading?
Which version configuration tool used in ur project?
What is the cumulative sum and moving sum?
Define enterprise data warehousing?
Explain the aggregator transformation?
What is aggregate cache in aggregator transformation?
What is workflow? What are the components of workflow manager?
I have a flat file, want to reverse the contents of the flat file
Differentiate between Load Manager and DTM?
Briefly describe lookup transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
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
When do you use sql override in a lookup transformation?
How you can differentiate between connected lookup and unconnected lookup?