tell me the datawarehouse defination,and it is maintaing
hystorical data meaning,what is the use
Answer / abhinaw prakash
Data warehouse is the coordinated,periodic copying of data
from different sources both inside and outside the
enterprise into an environment optimized for analytical and
informational processing.
By Historical data means that historical data will also be
kept along with the most recent data unlike the OLTP system.
| Is This Answer Correct ? | 0 Yes | 0 No |
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
What are the differences between joiner transformation and source qualifier transformation?
Router T/R is active but some people are saying it is also passive which is exactly right?
Which is costliest transformation? costly means occupying more memory?
if we r using aggregator we enabled sorted input but the records r not sorted what happen?
What are the phases in SDLC?
How do you load only null records into target? Explain through mapping flow.
How does a rank transform differ from aggregator transform functions max and min?
How the informatica server increases the session performance through partitioning the source?
My source table look like ID Name Location Salary 1 ran NULL NULL 1 NULL DELHI NULL 1 NULL NULL 1000 I want my output to look like ID Name Location Salary 1 ran Delhi 1000 What should be my approach to design a informatica mapping. Assuming my source is flat file not a Relation table so i cant use SQL.
What is a joiner transformation and why it is an active one?
How identifying bottlenecks in various components of informatica and resolving them?