How informatica recognizes mapping?
Answers were Sorted based on User's Feedback
Answer / srinivas
Ya. bt all are organized by Integration service .
Power center talks to Integration Service and Integration
service talk to session . session has mapping Structure .
these are flow of Excution .
| Is This Answer Correct ? | 10 Yes | 0 No |
How can we get multiple output values using an unconnected lookup transformation?
Can anyone give some input on "Additional Concurrent Pipelines for Lookup Cache Creation" ? I know that this property is used to build caches in a mapping concurently. But which values should I set into this ( i.e. 1 or 2 or 3 or something else ) for concurrent cache building ?
WAT IS TEXT LOAD?
3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
What is the procedure for creating independent data marts from informatica 7.1?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
why u go for dimensions ?
My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? means only one source qualifier has 2 columns like empno, sal. connected to same target as shown in above mapping.Is this mapping valid or any issues are there if we design like this?
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
How to handle decimal places while importing a flatfile into informatica?
can we override a native sql query within informatica? How do we do it?