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
Where do we use mapping variables in informatica?
What is the use of target designer?
What is the cumulative sum and moving sum?
Which is the t/r that builts only single cache memory?
what is song in infrmatica...?
How can repository reports be accessed without sql or other transformations?
What is the Rank index port in Rank transformation?
Explain what is informatica metadata and where is it stored?
Tell me about Propagate functions in informatica
What are the mapping parameters and mapping variables?
define galaxy repository in informatica
What are data-driven sessions?
What is aggregator transformation in informatica?
Design a mapping to load the cumulative sum of salaries of employees into target table?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?