Interested to Buy Any Domain ? << Click Here >> for more details...
how do u use sequence created in oracle in informatica?
Explain with an simple example
- 6 Answers
- 20126 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / kishore
Using SQL transformation we can call the sequence in
informatica.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the function of look up transformation?
where to store informatica rejected data?
How many ways are there to create ports?
How do you update the records with or without using update strategy?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
How you prepared reports for OLAP?
What is joiner transformation?
What is the cumulative sum and moving sum?
Explain the types of transformations?
What is the different lookup cache(s)?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
What is domain in terms of informatica?
What do you mean by blocking transformation?
What are junk dimensions?
How is union transformation utilized?
