Interested to Buy Any Domain ? << Click Here >> for more details...
How could we generate the sequence of key values without
using sequence generator transformation in the target ??
- 12 Answers
- 38164 Views
- TCS, Tech Mahindra, I also Faced
- E-Mail Answers
Answer Posted / arnab
either use oracle to generate the sequence number or use an
unconnected lkp transformation which looks up on the
target, get the max(value) of the column which has to be
incremented and increment the value by 1
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What is an aggregator 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 are the features of complex mapping?
How to load last n records of file into target table - informatica
what is the hint? how to use it to reduce the query processing in program?
What could be the possible resons of locks by user?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the fact table?
State the differences between sql override and lookup override?
What are Dimensional table?
Explain the scenario which compels informatica server to reject files?
How to differentiate between the active and passive transformations?
What is informatica?
According to his methodology what all you need before you build a datawarehouse
