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
Explain what is etl process? How many steps etl contains explain with example?
where we cannot use sorter Transformation. if we use then we will not get correct data?
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)
Explain about the data integration suite features?
What is initial load and what is full load?
Explain the use lookup tables and Aggregate tables?
what are the reports developed in sap bw project and what is the requirement for developing it?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is cube grouping?
Hi, I completed MCA in 2006.After studied Informatica,SQL server and basics of reporting tool in one of the training center in chennai.I got subject knowledge only.But I didn't go any job because I scared to face real time.Anyone please advice how can I enter again into this and anyone provide real time exposure with project.
What are various etl tools in the market?
how many maximum session supports to multiload in teradata ??
how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?
dimension object created in oracle can be imported in designer?how?
what is dynamic insert?