Please Help Members By Posting Answers For Below Questions
explain about your project architecture in ssis..could u please send to my mail..email@example.com
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
what happens if the info.server doesn't find the session
parameter in the parameter file?
how would u estimate the size of Lookup transform data and
how do u decide whether u need to do aggregations at
database level or at Informatica level?
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
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.
what are Lookup caches options? Including persistent caches.
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
what is the main role of FI on business
what make u disappointmnets in u r career
how to load the data to fact table?
how do use session mapping parameters ?(in which transformation)
what is the difference steps for data modeling?
how do u identify the changed records in operational data?
when u connect the repository for the first time it asks you
for user name & password of repository and database both.But
subsequent times it asks only repository password. why?