How could we generate the sequence of key values without
using sequence generator transformation in the target ??
Answer Posted / sathish
use expression transformation
create two ports
one is assigned with it to zero
another one is assigned in outputport with expression logic
is o_seq=v_seq+1;
Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is Index Caches size?
Reusable transformation and shortcut differences
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
what is the size of your data warehousing?
Which development components of informatica have the highest usage?
Define mapplet?
How do you convert single row from source into three rows into target?
Mention few power centre client applications with their basic purpose?
What is deployment group?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
what is index?how it can work in informatica
What is union transformation in informatica?
What is a stored procedure transformation?
What are the different types of transformation available in informatica.