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
- 38236 Views
- TCS, Tech Mahindra, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / g. manthiramoorthy
Create Two Port in Exp. Trans
v_temp : v_temp+1
o_seq : IIF(ISNULL(v_temp),0,v_temp)
| Is This Answer Correct ? | 18 Yes | 2 No |
Answer / kalyan
Do a lookup on the Target table with an Lookup SQl Override
Select MAX(FIELD_NAME), field 1 , field3 from target group
by field1, field2...
In the Expression increment the Max values of the field
which you just got from the lookup by 1.
Here MAX_FIELDNAME) is the Max value of the field you want
to generate the sequence of..
| Is This Answer Correct ? | 19 Yes | 4 No |
Answer / kamalakar
by using pre sql in source qualifier we can generate
sequence in the target
| Is This Answer Correct ? | 16 Yes | 3 No |
Answer / raghu
TAKE EXPRESSION TRANSFORMATION AND DOUBLE CLICK ON THE
EXPRESSION TRANSFORMATION AND ADD TWO NEW PORTS
1.SEQ
2.SEQ_OUT
1.IN THE SEQ PORT CHECK V=VARIABLEPORT THERE YOU MENTION
EXPRESSION SEQ+1.
2.IN THE SEQ_OUT PORT CHECK O=OUTPUTPORT THERE YOU MENTION
EXPRESSION IIF(ISNULL(SEQ),O,SEQ)
IT WILL GIVE CORRECT RESULT
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / kishore.g.n
It can be implemented throuh Lookup T/f,Develope the lkp
t/r with condition like NEXTVAL=CURVAL+1,Through this
conditon we can acheive.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / infastudent
use an oracle sequence and create a function to call it
inside informatica
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / m
Take Two Variable Ports in Expression V1,V2 and Output Port
V1=V2
Op=v1
V2=V1+1
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / 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 |
Answer / 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 |
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
How can a transformation be made reusable?
Where is the cache stored in informatica?
What is the use of incremental aggregation?
Performance tuning in UNIX for informatica mappings?
HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?
what is diff between IN and EXIT commands
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
My flat file source is C_Id 1-nov-2011 8-nov-2011 100 2000 1500 101 2500 2000 I want my Target as C_Id Week_Num Amt 100 45 2000 100 46 1500 101 45 2500 101 46 2000
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
how to join two flat files in informatica?
Teradata 
