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 / sukanta
You can call the DB sequence generator in the source
qualifier override sql query.Generate sql query first,add
the SG name in the sql query and alias as a port exist in
database table.
You will get the solution.I check it.
Regards
Sukanta
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Explain in detail scd type 2 through mapping.
What is the reusable transformation?
How can a transformation be made reusable?
What are the different clients of powercenter?
What are the reusable transformations?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is a mapplet/worklet in informatica?
What do you mean by filter transformation?
What are the different ways to implement parallel processing in informatica?
State the limitations where we cannot use joiner in the mapping pipeline?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Mention few power centre client applications with their basic purpose?
have u done any performance tuning? how u ll do?