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
While migrating the data from one environment to another environment how would you manage the connections?
Please let me know how to make encryption and decryption with example?
What is mapping debugger?
How to differentiate between the active and passive transformations?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Differentiate between reusable transformation and mapplet.
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the difference between source qualifier transformations source filter to filter transformation?
What are the new features of informatica 9.x developer?
What is expression transformation?
What is a snowflake schema?
How is union transformation utilized?
What are the popular informatica products?
What is the use of target designer?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process