Interested to Buy Any Domain ? << Click Here >> for more details...
What is incremental aggregation and how it is done?
- 8 Answers
- 38727 Views
- JPMorgan Chase, TCS, I also Faced
- E-Mail Answers
Answer Posted / raghvendra
incremental aggregation performs aggregation on incremented
data..so based on requirements if we can use incremental
aggregation then definately it will improve performance..so
while develop mapping always keep in mind this factor too...
| Is This Answer Correct ? | 7 Yes | 15 No |
Post New Answer View All Answers
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain the features of connected and unconnected lookup.
Plz can any one say me how to get the informatica certification materials and dumps
What all are steps in up gradation of Informatica server?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
how we can load rejected record's at run time?(not through bad files)
Explain the difference between a data warehouse and a data mart?
How to load the data from a flat file into the target where the source flat file name changes daily?
What are the types of caches in lookup? Explain them.
Explain the shared cache and re-cache?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What are connected or unconnected transformations?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is joiner change?
