Interested to Buy Any Domain ? << Click Here >> for more details...
Hi ETL gurus can any one tell me with a flow how to
implement SCD Type 1 and SCD Type 2 in a single mapping.For
some fields SCD type has to be implemented and for some
fields scd type has to be implementd..Thank in
advance..please let me know in case of any concerns...
- 1 Answers
- 3961 Views
- I also Faced
- E-Mail Answers
Answer / hemanth
yes, u can see the out put in single run,
in mappings tab one option is there, that is TARGET LOAD
ORDER.
yes we can do scd type1 and scd type2 in a single mapping
itself when the source is same for both. But with same
source we will never face that situation if so the changes
in source will reflect both scd1 and scd2.
| Is This Answer Correct ? | 1 Yes | 0 No |
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
How to add source flat file header into target file?
What r the type of indexes u generally used in informatica?
In any project how many mappings they will use(minimum)?
Explain grouped cross tab?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
Why we use partitioning the session in informatica?
What are the types of maping in Getting Started Wizard?
every DWH must have time dimension so now what is the use of the time dimension how we can calculate sales for one month,half-yr'ly,and year'ly?how we are doing this using time dimension.
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
why do we go for update strategy tr in SCD rather using the session properties?
Teradata 
