Answer Posted / guest
this is used in event rise and event wait task
implementations.
indicator file is nothing but the one which returns the
status
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what are the data modeling tools you have used?(polaris)
When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
what is session partitioning?
how does the server recongnise the source and target databases.Elaborate on this
where is the cache (lookup, index) created and how can you see it.
if i have a query as flat file how can we load data to target table
What is a mapping?
What is initial load and what is full load?
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.
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
What is full load & incremental or refresh load?
What are the types of Data Warehouse applications?
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.
what is Forward,Reverse and Re_engineering?
What is fact? What are the types of facts?
