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 to improve the performance of a session using sorter transformation?
What are session parameters ? How do you set them?
What is sq transformation?
What do you mean by worklet?
What are the differences between oltp and olap?
design of staging area?
What are the types of caches in lookup?
Do you find any difficulty while working with flat files as source and target?
explain one complex mapping with logic? sales project?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are active and passive transformations?
What is the way to execute pl/sql script using informatica mapping?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Is it possible to use a client with different version than that of its Informatica server?
What is informatica?