Answer Posted / sbvp
1.FLAG
2.versioning
3.date range
there is three types to implement scd2.
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
Explain the mapping variable usage example in informatica
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How to create a non-reusable instance of reusable transformations?
How do you load first and last records into target table?
How big was your fact table
how we can load rejected record's at run time?(not through bad files)
How can you define user defied event?
During the running session, output files are created by informatica server. Enlist few of them.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what are 3 tech challenges/ common issues you face?
What is different between the data warehouse and data mart?
When do you use sql override in a lookup transformation?
Explain the types of transformations?
What is data transformation manager process?
What is rank index in rank transformation?