Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / murthy
generally lookup is used to search for a record.in realtime
mainly people use this to fetch the key values doing a
lookup on the other table.
| Is This Answer Correct ? | 3 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?
Is hadoop a etl tool?
What are your responsibilities as an etl tester?
Explain the use lookup tables and Aggregate tables?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Can u access a repository created in previous version of Informatica?
where we cannot use sorter Transformation. if we use then we will not get correct data?
Explain the key challenges that you face while performing etl testing.
what happens if the info.server doesn't find the session parameter in the parameter file?
What is data modeling and data mining?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what is session partitioning?
How to increase performance without changing anything in mapping.( In prod)
Explain the difference between etl tool and olap tools?
how would u estimate the size of Lookup transform data and index cache?
