Interested to Buy Any Domain ? << Click Here >> for more details...
indatastage 8.1 surrgoate key generates seqences numbers
write but there is limite value i want to reset the seqence
after gettting some highest value like i want o/p like this
1 2 3 4 5 .............10000 1 2 3.........10000
- 1 Answers
- 5093 Views
- TCS, I also Faced
- E-Mail Answers
Answer / bhaskar bokkala
Use the Sequence Generator transformation and set the end
value is 10000 and also click the cycle property.
| Is This Answer Correct ? | 3 Yes | 2 No |
if i have a query as flat file how can we load data to target table
what are the different Reporting and ETL tools available in the market?
what is session partitioning?
what happens if the info.server doesn't find the session parameter in the parameter file?
we have 1 source table containing 100 records. now we have to transfer first set of 1-10 (i.e1-10) records to one target table and another set of 1-10(11-20) records to other target table and continue like that till 100th record
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
Hi can anyone write query for the below input and output Table 1 col 1 100 Null 200 300 Table 2 col1 Null 400 700 800 o/p 200 700 800 2)sql col 1 contains 23x-5-45 26x-12-45 28x-10-50 o/p middlevalue should be greater than 10
how do u set partition points in the mapping?
what is a test load?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
What are the three tiers in etl?
What are the etl testing operations includes?
Teradata 
