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
- 3901 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 |
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.
which is better perfomancewise lookup or joiner and why?can anyone give example?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,
Did u used latest transformations of 8.6.0? for what?
Explain the flow of data in Iinformatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
List the transformation in informatica.
How can i send first half of the records to one target and Remaining to other target?
How can you generate reports in informatica?
what is mean by flag 4 in update strategy t/r
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
what is the necessity to use update strategy?(except for updates)
Teradata 
