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???
Answer Posted / 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 |
Post New Answer View All Answers
Write the unconnected lookup syntax and how to return more than one column.
How do you load unique records into one target table and duplicate records into a different target table?
differences between service based and product based?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What does command task mean?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is xml source qualifier transformation in informatica?
Why update strategy and union transformations are active? Explain with examples.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Define Pmrep command?
What are the new features of informatica 9.x in developer level?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Where are the source flat files kept before running the session?
What is dimensional table?