Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the first row without using rank t/r?
- 7 Answers
- 12447 Views
- iGate, I also Faced
- E-Mail Answers
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
Explain dynamic target flat file name generation in informatica
What are the differences between a connected lookup and unconnected lookup?
What are the reusable transformations?
What you know about transaction control transformation?
What is the function of aggregator transformation?
Enlist the tasks for which source qualifier transformation is used.
How can we store previous session logs?
How can we use mapping variables in informatica? Where do we use them?
What are the advantages of informatica?
Where are the source flat files kept before running the session?
What is a predefined event?
What is the use of source qualifier?
What do you mean by worklet?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
