Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12410 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / moorthy g
SQ-Sorter-Seq-Exp-Fiter(nextval=1)-Target
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is an expression transformation in informatica?
What is the meaning of decode in informatica?
What are the reusable transformations?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain your project of banking domian.
What are the differences between source qualifier and joiner transformation?
What is the function of look up transformation?
Describe data concatenation?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is the -ve test case in your project.
How many ways are there to do 'remove duplicate records in informatica'?
Parameter and variable differences
What is a filter transformation?
How can we improve session performance in aggregator transformation?
