how do u use sequence created in oracle in informatica?
Explain with an simple example
- 6 Answers
- 18163 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vijay
Using Stored Porcedure Transformation we can call the
Sequence Generator
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / vijay
By using the Stored Procedure
please corect me if am wrong
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / kishore
Using SQL transformation we can call the sequence in
informatica.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / nidhi
yes,Using stored procedure t/r we can do that..
I can give u brief idea.. i didnt tried this, sorry if it
goes wrong..
while writing the SP in oracle,we will call n execute the
existing sequence using execute immediate clause..
The o/p port of the SP t/r will be mapped to the sequence no
column in the target.
If i am wrong let me knw.. Thank you
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / madhavan eyunni
Hello boss, did you tried ?
Let's try, then give me exact ans... ok
| Is This Answer Correct ? | 0 Yes | 5 No |
I've a denormalized table EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to insert the record into target in the format that, there will be 2 target rows for 1 source record. In target the row needs to be inserted as: ROW1: empno,ename,addr1,phone ROW2: empno,ename,addr2,fax,email And I'm not allowed to normalize transformation. How to achieve?
What does reusable transformation mean?
Hi , Please help how to achieve the following scenario. I have a source table like this. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU I need the data in the target table like below. Rollno name class university 1 Raj 1st Sku 2 Ram 2nd SVU 3 Sam 3rd OU 4 Rajesh 5th SKU The Last row values we have.. and we have to append this last row in the target table. Thanks and Regards Nataraj V
I have a scenario with router transformation. but i dont want to capture records from default group. how can we achieve this.
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...
How can repository reports be accessed without sql or other transformations?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain what is informatica metadata and where is it stored?
What are the differences between joiner transformation and source qualifier transformation?
what are the Methods For Creating Reusable Transformations?
Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj
Teradata 
