Please Help Members By Posting Answers For Below Questions
how do u really know that paging to disk is happening while
u are using a lookup transform?
what is dynamic insert?
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?
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?
tell me few points when u become TL
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
how to connect to a flatfile through ftp in informatica
how do u estimate the number of partitions that a mapping
really requires? Is it dependent on the machine configuration?
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.
can be used COM component in Informatica ?
how do u set partition points in the mapping?
where are the log files generally stored.Can you change the
path of the file.what can the path be?
how would u estimate the size of Aggregator transform data
and index cache?
what is the difference steps for data modeling?
what are the data modeling tools you have used?(polaris)