why we are using surogate key in real time give me
explanation
Answer Posted / davan
Mainly we r using...the maintain the historical data.and we
can get the data diffrent sources so we can idetified the
every record.
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What are junk dimensions?
What are 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?
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?
Explain what are the different types of transformation available in informatica.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Why update strategy and union transformations are active? Explain with examples.
Explain the types of transformations?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to partition the Session?
What is complex mapping?
Explain incremental aggregation in informatica
In warehouses how many schemas are there?
What is resilience time?
What is meant by query override?
Scheduling properties,whats the default (sequential)