how we load the data from source to staging area
Answers were Sorted based on User's Feedback
Answer / manik
By using one to one mapping we can load data into staging area like how we will load Flat file data into staging relational table.
| Is This Answer Correct ? | 0 Yes | 0 No |
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
how we can update a target table without update strategy and update override?
what is metadata?
what is curr val use for in sequence generator?
what is fact and what types of fact tables is there
In ur current projectu have done any performance tuning of mappings?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
which quality process u can approach in ur project
Tell me about informatica architecture.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.