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
- 3772 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 |
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Can anyone please send me the latest informatica dumps (power center 8.1.1) for all the three exams? My mail id is yokilamai@gmail.com
what is the use of server manager?
hoe to access second value in mapping parameter if it is having more than one value ?????????????
what are the data modeling tools you have used?(polaris)
when should one create lookup transformation ?
what is session partitioning?
Explain about round-robi?
What are the names of the layers in etl?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Explain and compare etl & manual development?
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?
Teradata 
