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
purpose?
- 1 Answers
- 4145 Views
- I also Faced
- E-Mail Answers
In case a table is getting changed constantly,... u need to
make a lookup of the target table with the source table.
and put an incremental load logic. If you want the logic I
can explain this anytime. :)
| Is This Answer Correct ? | 0 Yes | 1 No |
What is etl process?
when will use SQL override in a lookup transformation?
Explain do we need an etl tool? When do we go for the tools in the market?
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
explain the methodology of Data Warehousing?(Polaries)
Mention few test cases and explain them?
how would u estimate the size of Aggregator transform data and index cache?
what are the concerns of OLTP and DSS systems?
What is the difference between round-robin partitioning and hash partitioning?
Explain what is etl process? How many steps etl contains explain with example?
Identifying the bottlenecks in various components of Informatica and resolving them.
What is a mapping, session, worklet, workflow, mapplet?
Teradata 
