If a table contains 100 records we have to fetch 50-100
records from source to target?how
Answer Posted / tauseef
hai Tauseef,
as per my knowledge we can Fetch 50-100 records
by using rownum>=50 in source qualifier it self after generation sql query
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
permutations of mapplet
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is a sequence generator transformation?
without table how to come first record only in oracle?
How can we improve session performance in aggregator transformation?
Can we override a native sql query within informatica?
Explain the scenario which compels informatica server to reject files?
If informatica has its scheduler why using third party scheduler?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What do you mean by filter transformation?
What is a passive transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
How would you join a node to the already existing domain?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is exclusive and normal mode for repository services?