Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 13158 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagesh
using FTP we can achieve this
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the various tools used in etl?
what are the data modeling tools you have used?(polaris)
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.
how do u identify the changed records in operational data?
What is partitioning? Explain about round-robin, hash partitioning.
How can we use external procedural logic in informatica?
What are the different Lookup methods used in Informatica?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
how would u estimate the size of Aggregator transform data and index cache?
what is data modeling?
Can we create Hierarchies in generic datasources?
Explain different types of partitioning?
Explain the use lookup tables and Aggregate tables?
In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
how many maximum session supports to multiload in teradata ??
