Without using Lookup & Sequence Generator, How to generate
Sequence?
- 5 Answers
- 12397 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / brahma
using set count varriable in expression transformation.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / kalu bhai
without using sequence genarerater and lookup, we can
create sequence numbers in two ways 1.using of expresson
transformation 2. stored procedure transformation,
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
Using oracle database sequence gen(from dual table)
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / naveen
by using mapping variable we can also create a sequence number
| Is This Answer Correct ? | 1 Yes | 1 No |
What are the Advantages of de normalized data?
How to update records in Target, without using Update Strategy?
Could you explain what is enterprise data warehouse?
What is the advantage of informatica?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
Can we override a native sql query within informatica?
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
What are the tasks that source qualifier performs?
How the informatica server increases the session performance through partitioning the source?
What is a snowflake schema?
Hi, I am unable to connect ports from two Active trasformations to another active transformation ? Why is it so? Why it is designed like that? Some rules has been designed like this that is We can't connect passive and another passive to active.Can any one please letme know all these rules. Ex:- I am trying to connect filter1 and filter2 to another filter. Please answer me Advance Thanks
What is a filter transformation and why it is an active one?
Teradata 
