When you have 2 servers in two different time zone and if
you need to extract data from 1 server and load it in
another server, how do you go about it? Best method to be
used.
Answer Posted / nagesh
using FTP we can achieve this
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is dynamic insert?
What are the different Lookup methods used in Informatica?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Difference between flat files and relational sources?
how do u set partition points in the mapping?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.
What is etl process?
What is tracing level? How many types of transformations supported by sorted input?
what are the reporting tools and difference between them?
What is a staging area? What is the purpose of a staging area?
What is tracing level and what are the types?
What is a mapping, session, worklet, workflow, mapplet?
Do we need an ETL tool? When do we go for the tools in the market?
what is the difference between cardinality and Nullability?
Explain me ETL project architecture in Detail?