Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql override?what is the use of it?
- 4 Answers
- 16232 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / venkateshmalneni
we can write the sql queries in sql override.by using this sql override we can reduce the no of t/r in a mapping.
if no please let me know the correct answer
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is dimensional table? Explain the different dimensions.
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How do you set a varible in incremental aggregation
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Define sessions in informatica etl?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
difference between repository database and repository service?
what is the hint? how to use it to reduce the query processing in program?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
4 yrs etl devloper roles and responsibilities?any body give solutions
explain about unit testing? in real time?
Explain what transformation and how many are there in informatica?
Which is the t/r that builts only single cache memory?
What is standalone command task?
in reporting we add some new objects,how we get the count of the newly added objects to the report
