Interested to Buy Any Domain ? << Click Here >> for more details...
1.how to generate even numbers in surrogate or tranformar
stage ?
2. how many ways to remove duplicate values?
- 5 Answers
- 15126 Views
- Gallega, TCS, I also Faced
- E-Mail Answers
Answer Posted / pavan
To generate even numbers using transformer, we can make use
of stage variables. declare a stage variable say SV1 and
initialise it to 0. In the derivation of that stage
variable increment it by 2 which looks like SV1+2. By doing
this we can generate even numbers.
mail me @ akellapavankumar@gmail.com for more info.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Differentiate between validated and Compiled in the Datastage?
What is the difference between datastage and informatica?
What are the areas of application?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Explain datastage architecture?
Explain the situation where you have applied SCD in your project?
How you Implemented SCD Type 1 & Type 2 in your project?
On which Dimension Table you implemented SCD Type in your Project
Can we use target hash file as a lookup ?
how to write server Routine coding?
how to add a new records into source?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
in oracle target stage when we use load option and when we use upsert option?
1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do
