Interested to Buy Any Domain ? << Click Here >> for more details...
hi talents,
how do u get sequece numbers with oracle sequence generator
function in informatica.... i dont need to use sequence
generator transformation..... how do u achieve this???
- 3 Answers
- 9044 Views
- HP, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jz
If you want Oracle seq then go for SQL t/r in query mode. In
that write a query ( select Sequence_name from dual) in o/p
port. You will get your result.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / santosh kumar sarangi
you can use the mapping variable with datatype as integer
and aggregation type as count. So for every row it will
generate the number.
| Is This Answer Correct ? | 0 Yes | 1 No |
In any project how many mappings they will use(minimum)?
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
Explain incremental aggregation in informatica
Can you copy the session to a different folder or repository?
What are the modules in Power Center
What is workflow monitor?
what is $$$$?
How do you load unique records into one target table and duplicate records into a different target table?
What are the scheduling options to run a sesion?
Using Expression transformation how to remove duplicate records from a relational source?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
Can I create one wrkflw which will run different wrkflws on schedule time?
Teradata 
