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
- 9075 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 |
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
What is persistent lookup cache?
How can you run a session without using server manager?
Different sorts of metadata that stores in the storage facility?
What is a shortcut and copy in Informatica and how two are different with each other?
Source is a flat file and want to load unique and duplicate records separately into two separate targets; right??
Define mapplet?
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
can any one give some examples for pre sql and post sql(Except dropping and creating index).
i have source like this ID 1 2 3 4 sal 1000 2000 3000 4000 and how to load target like this o_sal 1000 3000 6000 10000 can you plz give a sol using informatica
Define joiner transformation?
what is unique constraint error ?
Teradata 
