Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sunil
)At DB level we can simply DROP the stagin table.
2)then Create Target table at DB level.
3) Directly LOAD the records into target table.
NOTE: It is recommended to use staging area
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to extract the informatica rejected data?
How union transformation is used?
Enlist the various types of transformations.
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is native users?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain the use of aggregator cache file?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is source qualifier transformation in informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
Explain what transformation and how many are there in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is the function of look up transformation?
What are the types of lookup transformation?
How does the aggregator transformation handle null values?
