Answer Posted / fatima
source qualifier is also a table, it acts as a
intermediator between source and target metadata and, it
also generates sql, which creating mapping in between
soucre and target metadata.
| Is This Answer Correct ? | 25 Yes | 8 No |
Post New Answer View All Answers
Implementation methodology
Can we change Dynamic to Static or Persistent cache? If so what happens?
How to improve the performance of a session using sorter transformation?
What is update strategy transform?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
list out all the transformations which use cache?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Briefly define reusable transformation?
Can informatica load heterogeneous targets from heterogeneous sources?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
can we override a native sql query within informatica? How do we do it?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the tasks that can be performed using sq?
What is the use of target designer?