how do u use sequence created in oracle in informatica?
Explain with an simple example
Answer Posted / sujay
by writing sql override in the source qualifier by calling
sequence which you have created in oracle
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Enlist the various types of transformations.
How can one identify whether mapping is correct or not without connecting session?
What is Data Caches size?
What is an expression transformation?
What is the surrogate key?
Define filter transformation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
Enterprise data warehouse your projects phase by phase explain?
Do you find any difficulty while working with flat files as source and target?
explan ur project architecture?
What is workflow monitor?
What is sq transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
In how many ways we can create ports?