Answer Posted / ram kumar
SCD 2 is critical Mapping
| Is This Answer Correct ? | 2 Yes | 9 No |
Post New Answer View All Answers
Performance tuning( what you did in performance tuning)
What are the static cache and dynamic cache in informatica?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are active transformations.
How can you increase the performance in joiner transformation?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What are the types of caches in lookup?
How we can create indexes after completing the load process?
Explain sessions?
Which transformation should we use to normalise the COBOL and relational sources?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Briefly describe lookup transformation?