Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ankit kansal
Lookup is used to check whether the row corresponding the incoming row is present or not and if yes then perform some logic and if not then do some other like we use to do it case of SCD2.
So, It is purely a left outer join where left table is your source table.
http://deepinopensource.blogspot.in/
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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?
What is full load & incremental or refresh load?
what is different between sequential batch and concurrent batch and which is recommended and why?
What is a mapping, session, worklet, workflow, mapplet?
can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?
what is the use of structures?how many nodes can u create in a structure?
how do u really know that paging to disk is happening while u are using a lookup transform?
Explain about etl data integration software?
Explain etl mapping sheets?
Identifying the bottlenecks in various components of Informatica and resolving them.
what are the session parameters? How do u set them?
what is data modeling?
what is Forward,Reverse and Re_engineering?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
what is a worklet?
