wht is full process of Information source to target
just like stg to productuon and development
Answer / krishna
Initially data comes from OLTP systems, of a company, which
get loaded into a database or flatfiles with the help of
legacy systems or any pre defined methods. from here data
is transferred to the staging database applying business
logic with the help of informatica or other ETL tools. at
times stage to target is also loaded using informatica
mappings. these are transferred to another QA(quality
analysis database) in XML files. from there deployment is
done onto the production environment.
| Is This Answer Correct ? | 6 Yes | 3 No |
How can we create index after completion of load process?
what is constraint based loading
what is system requirement(SR) & business requirement(BR)?
what is hash table in informatica?
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
Write the prerequisite tasks to achieve the session partition?
What is the main difference between a Joiner Transformation and Union Transformation?
Target is zero file and how can you send the email?
i have thousand records in my source(flat file) i wanna load 990 records i don't want load first 5 records and last 5 records at informatica level?
Explain the different kinds of facts.
what is meant by data driven.. in which scenario we use that..?
How might one distinguish in the case of mapping is right or not without associating session?