i have n number of records in my source, i want first and
last record to my target. how can u implement this scenario .
Answer Posted / rakesh
use 2 rank transformations, 1st one with top1 and 2nd one with bottom1 and connect them to 2 instances of target..
| Is This Answer Correct ? | 3 Yes | 8 No |
Post New Answer View All Answers
While migrating the data from one environment to another environment how would you manage the connections?
Explain sessions?
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.
tell me the rules and responsblites in our project(my project is development)
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is rank index in rank transformation?
Describe an informatica powercenter?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Design time, run time. If you don't create parameter what will happen
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is lookup transformation?
How might one distinguish in the case of mapping is right or not without associating session?
What is the sequence generator transformation in informatica?
What is meant by pre and post session shell command?
Under which circumstances, informatica server creates reject files?