Answer Posted / vamse
not necessarily left outer join. Its inner join most of the time.
Loop up is generally used to fetch data for a particular filter condition.(matching critria should take a particular value from it.
Main table is usually large and look up table is small in ideal scenario.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
what is the meaning of upgradation of Repository?
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.
how would u estimate the size of Aggregator transform data and index cache?
What is partitioning? Explain different types of partitioning?
What is initial load and what is full load?
how to connect to a flatfile through ftp in informatica
what are the reporting tools and difference between them?
How etl testing is different from database testing?
Give the benefits of data integration suite?
Identifying the bottlenecks in various components of Informatica and resolving them.
What are materialized views & where do we use them?
where are the log files generally stored.Can you change the path of the file.what can the path be?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
how do u extract data from different data sources explain with an example?
