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
- 38234 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
complex mapping ur project u r invlve can u explain and give real time example give me ?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
what is the size of your data warehousing?
What is informatica?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How we can use union transformation?
What is a sequence generator transformation?
What is native users?
What are session parameters ? How do you set them?
What is a sorter transformation?
what is index?how it can work in informatica
What is the function of aggregator transformation?
What are the types of caches in lookup?
Reusable transformation and shortcut differences
