how to get the first row without using rank t/r?
Answer Posted / abhishek kumar
step 1
if first row h as not null then we can use first()
function in aggregator T/F.
step 2
use sequence generator T/F And filter T/F write condition
nextval=1
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What is standalone command task?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What is InformaticaPowerCenter?
What are the reusable transformations?
What will be the approach?
What is a joiner transformation and why it is an active one?
How can we use batches?
What is depict expression change?
Explain in detail about scd type 1 through mapping.
can u give example for factless fact table
how to load dimension table and fact table. plz tell me the steps.
Can we get 1st record through Informatica(without sequence number).
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is meant by query override?
What is the reusable transformation?