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
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
hi real timers . iam waiting for ur reply regarding ETL TESTING
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
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 kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Which transformation should we use to normalise the COBOL and relational sources?
can anyone explain me about retail domain project in informatica?
What is the surrogate key?
How many number of sessions can one group in batches?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is substr in informatica?
What is exclusive and normal mode for repository services?
Explain the different kinds of facts.
How you can differentiate between connected lookup and unconnected lookup?