If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / rajesh
in rownum not support grater than so use in filter
transformation iif(rownum<50,false,true)
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is target designer and target load order?
What is persistent lookup cache?
What is event and what are the tasks related to it?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is a filter transformation and why it is an active one?
What is domain in terms of informatica?
Can we override a native sql query within informatica?
What are the types of presistent cache in look up tr.
Briefly explain the aggregator transformation?
What is the need for an etl tool?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
what is SDLC way of code development?
how to load rows into fact table in data warehouse
What is meant by active and passive transformation?