My source table having some records ,i want load 1st record
and last record into one target?
Answer Posted / kiran
take two rank transformations and take reusable sequence
generator connect the next value to both rank transformations
and in the rank transformations properties for the first one
take top and number of ranks as 1 for the second take bottom
and number of ranks 1 at the last take two instances of tgt
connect the ranktrans to two instances
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to delete duplicate row using informatica?
What are the types of presistent cache in look up tr.
Enlist the differences between database and data warehouse.
explan ur project architecture?
complex mapping ur project u r invlve can u explain and give real time example give me ?
How many input parameters can exist in an unconnected lookup?
Plz can any one say me how to get the informatica certification materials and dumps
what are factless facts? And in which scenario will you use such kinds of fact tables.
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
differences between service based and product based?
Differentiate between router and filter transformation?
What does refresh system mean, and what are its distinctive choice?
How to generate sequence numbers without using the sequence generator transformation?
How can informatica be used for an organization?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures