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


Please Help Members By Posting Answers For Below Questions

Under what conditions selecting sorted input in aggregator will still not boost session performance?

814


How can we delete duplicate rows from flat files?

948


What is a router transformation?

810


write a query to retrieve the latest records from the table sorted by version(scd)

824


What is the status code in stored procedure transformation?

878


Briefly define reusable transformation?

830


Is it possible to revert a global repository to local one and why?

838


Partition, what happens if the specified key range is shorter and longer

2208


generate date / time dimension in informatica

873


What are the types of lookup transformation?

832


To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

867


What are mapplets? How is it different from a Reusable Transformation?

834


What do you mean by filter transformation?

731


If informatica has its scheduler why using third party scheduler?

998


How does a rank transform differ from aggregator transform functions max and min?

895