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???
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 |
There is a table with emp salary column how to get the fields belongs to the salary greater than the average salary of particular department. Write a query
when we dont use aggregator in mapping ?
Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance
I still need further explanation about the difference between active and passive transformation with some examples.Thank You
Mapplets can you use an active transformation in a mapplet,
What are the out put files that the informatica server creates during the session running?
what is fact and what types of fact tables is there
What is the query to find nth highest salary? What is the use of cursors?
How is Data Models Used in Practice?
hi all, can anyone tell where i will get good informatica training in Pune? thanks in advance.
What is predefined event?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .