What are the disadvantages of Sequence Generator T/R?
Answers were Sorted based on User's Feedback
Answer / mallikarjun
While migrating the code we will get a dialouge box in that there are two
values retain and replace but i don't think about reset.
if you are deploying into production environment, you may want to retain the
current values for sequence Generator transformation in the target folder
instead of replacing them.
To retain values, check the box
uncheck for the replace.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / jz
During Migrating into Production need to reset the value in
the Seq gen t/r.
| Is This Answer Correct ? | 7 Yes | 4 No |
Answer / akhil4
using sequence generator t/r, u can not create sequence with alphabets
| Is This Answer Correct ? | 8 Yes | 7 No |
What is Session and Batches?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What exactly mentioned in High level design document.can somebody explain me sequentialy.
any one can informatica metirial to me ple forwrd to my mail id; gbalireddy@gmail.com
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
Define Incremental Aggregation?
How can yoU create or import flat file definition in to the warehouse designer?
how to duplicates from expression transformation without using sorter before that
In any project how many mappings they will use(minimum)?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
Plz..let me know differences between Informatica 7.1 and 8.1?
what are the different types of transformation available in informatica and what are the mostly used ?