how to get the first row without using rank t/r?
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
What are the limitations of joiner transformation?
Can we create multiple integration service on single repository?
How identifying bottlenecks in various components of informatica and resolving them?
In informatics server which files are created during the session rums?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the different lookup cache(s)?
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?
What is the maplet?
Why is sorter an active transformation?
Explain what are the different types of transformation available in informatica.
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is sorter transformation?
How do you take back up of repository?
What is incremental aggregation?
What is the function of union transformation?