can u apply SCD2 on flat file tgt? if yes wat is the procedure?
Answer Posted / guddu kumar mehra
We can not update a record in a flat file as we need a Key column to update the record but in flat file we can not have a key column.
So we can not implement SCD type 2 on flat files.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is transformation?
What is informatica? Why do we need it?
Can we create two repositories on same database instance in oracle?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Differentiate between source qualifier and filter transformation?
What are the modules in Power Center
What is the function of look up transformation?
How many ways a relational source definition can be updated and what are they?
How to create Target definition for flat files?
How to join three sources using joiner?
Explain the different lookup methods used in informatica?
Differentiate between a database and data warehouse?
Briefly define a session task?
Different sorts of metadata that stores in the storage facility?
Implementation methodology