Answer Posted / pune.rohitsharma
my ans is
1)date range
2)key
3)flag
here i have one thing to say
what about with pk key and with out pk will it come into
picture when we are talking about diff ways of implementing
SCD type 2
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is data transformation manager process?
How is union transformation utilized?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Why union transformation is an active transformation?
Write the program through which the records can be updated?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is a passive transformation?
How many types of sessions are there in informatica.please explain them?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is different between the data warehouse and data mart?
server hot-ws270 is connect to Repository B. What does it mean?
explain one complex mapping with logic? sales project?
What is data movement mode in Informatica and difference between them?
Define mapplet?