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
tell me few points when u become TL
what are the types in error loging?
Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .
What is etl tool in hadoop?
List few etl bugs?
When do we analyze the tables? How do we do it?
What is a mapping?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
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?
Can we create Hierarchies in generic datasources?
When do we go for the tools in the market?
Explain what are the various etl tools in the market?
can cubes contain measures ?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
what are the production issues in datastage?