Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql override?what is the use of it?
- 4 Answers
- 16250 Views
- Sonata, I also Faced
- E-Mail Answers
Answer Posted / soujanya
It is a process of writing user defined SQL queries to
define SQL joins,source filters, sorting input data and
eliminating duplicates
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Separate from a database, an information bazaar, and an information stockroom?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Briefly define a session task?
Enlist the tasks for which source qualifier transformation is used.
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
How to create Target definition for flat files?
How is union transformation utilized?
explain abt ur project architecture?
What is a rank transform?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
In informatica workflow manager, how many repositories can be created?
Differentiate between sessions and batches?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Performance tuning( what you did in performance tuning)
