Answer Posted / suresh
lookupT/r is passive tranforamtion where as joiner is active t/r
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
Design a mapping to load a target table with the following values from the above source?
Describe expression transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How can repository reports be accessed without sql or other transformations?
What are the types of presistent cache in look up tr.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Why do we need informatica?
Explain informatica architecture - version 8 / 9
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?
design of staging area?
How an expression transformation differs from aggregator transformation?
can u give example for factless fact table
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is a rank transform?
Explain the scenario which compels informatica server to reject files?