how we load the data from source to staging area
Answer Posted / cm
use sql loader
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What does update strategy mean, and what are the different option of it?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Different qualification between a related rotate toward the sky and isolates look upward?
How to partition the Session?
Why do we need informatica?
Differentiate between a database and data warehouse?
Explain sql transformation in script mode examples in informatica
tell me about your project functionality
How to improve the performance of a session using sorter transformation?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Define filter transformation?
Mention some types of transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?