Hi 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....
- 1 Answers
- 2979 Views
- I also Faced
- E-Mail Answers
Answer Posted / kiran ghatage
You will find this in following examples...
https://community.informatica.com/solutions/mapping_implementing_scd1_using_md5
https://community.informatica.com/solutions/mapping_scd_type_2_effective_date
https://community.informatica.com/solutions/mapping_scd_type_2_versioning
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
if we have a delimiters at unwanted places in a flat file how can we over come those.
While importing the relational source definition from the database, what are the metadata of source that will be imported?
What do you mean by channel change?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is update strategy transform?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
EXL informatica Questions
What is a surrogate key?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What is the difference between source qualifier transformations source filter to filter transformation?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Which development components of informatica have the highest usage?
Scheduling properties,whats the default (sequential)
How we can create indexes after completing the load process?
