How can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).
Answers were Sorted based on User's Feedback
Answer / krishna
Use database Sequence generator call this from stored
procedure or dummy lookup query
or
You can also use expression transformation. Create two
ports one is variable and assign it to 0 and another one is
output port ind Write the logic to increment it
(o_seq=v_Seq+1)
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / vijay
You can also use expression transformation. Write the logic
i = 0 and increment it in another column. Give this column
as output.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / manikandan
I think your Express increment is not clear because when the second record will comes again it that variable is initialize to zero.
So we do to capture into Variable by SetVariable()
Or
The Use target lookup and return the column(SNo) which you what to populate the seq number.
Check in Express(before Target), If(isNull(SNo), 1, SNo+1). Connect this to SNo in Target
Is This Answer Correct ? | 3 Yes | 0 No |
How big was your fact table
what is filelist concept in informatica
.prm wirh repalce .txt is possible?
there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source
How to eliminate 1st and last rows from the source and load the inbetween rows.
I have table name called Team and I have name and DOJ in that table in oracle, when I retrive the table in Informatica DOJ shows with date and time , I want want to know is it possible to get only date(MMDDYYYY) in the date data type,
what is the difference between stop and abort
What is the difference between STOP and ABORT options in Workflow Monitor?
Useful UNIX commands regular/frequently used
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
can we see default group,when we use router?if yes how?
can any one explain me about junk dimension