Answer Posted / sai suresh
Staging area is a where data transformaions takes place. It
is temparly storage area . Transformations like "DATA
SCRUBBING, DATA CLEANSING,DATA AGGREGATION,DATA MERGING"
The above transformations are takes place in the staging
area, in staging area data transformed from one format to
required business format then it will load into the target.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is persistent lookup cache?
lookup transformation with screenshots
What are the different transaction levels available in transaction control transformation?
Enlist some properties of sessions.
What is the use of source qualifier?
What is status code in informatica?
What is sq transformation?
Define Pmrep command?
Explain the code page compatibility?
What is the need of an ETL tool?
What all join we can perform in LOOKUP transformation?
Clarify the utilization of aggregator cache record?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How can you generate reports in informatica?
How to create or import flat file definition in to the warehouse designer?
