Interested to Buy Any Domain ? << Click Here >> for more details...
how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
- 0 Answers
- 2231 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
how to load the data to fact table?
list the transformation used for the following:Heterogeneous sources,Homogeneous sources,Find the 5 highest paid employees with in a dept,create a summery table,generate surrogate keys
Explain about round-robi?
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.
Explain do we need an etl tool?
What are the names of the layers in etl?
What are snapshots?
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.
If you concatenate data from a normalizer transformation,the ports you concatenate cannot include OCCURS(T/F).
what are Lookup caches options? Including persistent caches.
what is the difference between OLTP database and data warehousing database?
Teradata 
