What is factless fact schema?
Answer / mln
The fact which does not contain any facts or mesaurables.
Ex:the fact table which is used to store the students
information is he came to school or not cannot have weather
they are attending all classes.
which is a measure
| Is This Answer Correct ? | 5 Yes | 4 No |
write asql query to filter improper date format? date 20-apr 11-mar-2010 30-may-2010 feb-2009 i want the output date 11-mar-2010 30-may-2010
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
What is checksum termnology in informatica? Where do you use it ?
3 Answers Chase, Cognizant, Deloitte,
I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
How to load query faster,so that It will take less time to load?
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?
Write the prerequisite tasks to achieve the session partition?
scd methodology?
TELL ME ABOUT WORK FLOW SCHEDULING?
if i have a delimited file as source so how can we seperate this file into three diff targets?