How can i generate Seqence Numbers to Tagret Table
(with out using Seqence Gen Trans,Rank Trans).
Answer Posted / ganesh
You can handed this issue, using expression transformation.
1) create one variable port and declare it as Integer and
assign the value to Output port.
e.g: var_count Integer var_count+1
out_count Integer var_count
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
how to load dimension table and fact table. plz tell me the steps.
What is sequence generator transformation in informatica?
What are the uses of etl tools?
What is dimensional table?
What are multi-group transformations?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
What is the status code in stored procedure transformation?
State the differences between sql override and lookup override?
How many ways are there to create ports?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
Explain the features of connected and unconnected lookup.
Define Pmrep command?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
Have you worked with/created Parameter file