in which situations do u go for sequence generator ?
Answer Posted / mahesh
In the Fallowing Situations we use Sequence Generator
Transformation
1)Creating Primary Key Values
2)Replacing The Missing Key Values
3)When You Apply the Cycle Through a Sequential Range Of
Numbers
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are multi-group transformations?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
how to load rows into fact table in data warehouse
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
How to load last n records of file into target table - informatica
what is mean by complex business rule ?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is Data Caches size?
What are the mapping parameters and mapping variables?
What are the modules in Power Center
Name at least 5 different types of transformations used in mapping design and state the use of each.?
can we override a native sql query within informatica? Where do we do it?
Write the unconnected lookup syntax?
How do you load alternate records into different tables through mapping flow?