Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of Sequence Generator T/R?
- 3 Answers
- 16644 Views
- Zensar, I also Faced
- E-Mail Answers
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 the difference between view and materialised view?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
What is difference between a gateway node and worker node?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?
How to load data in informatica ?
What is a Shortcut and What is the difference between a Shortcut and a Reusable Transformation?
what is the use of Data Mart?
How many ways a relational source definition can be updated and what are they?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
Teradata 
