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 / s
use Time stamp on the server. such that we can worked on
the time zone & set as per time & have data.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
how would u estimate the size of Aggregator transform data and index cache?
What are the types of Data Warehouse applications?
What is data modeling and data mining?
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?
Can anyone explain me a scenario from banking and finance...more precisely a mapping
what is the difference between cardinality and Nullability?
Explain the key challenges that you face while performing etl testing.
what are the data modeling tools you have used?(polaris)
What are materialized views & where do we use them?
flat filevalidation in informatica
State the differences between shortcut and reusable transformation
What are the names of the layers in etl?
What is partitioning? Explain about round-robin, hash partitioning.
Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in