Answer Posted / bsgsr
mappings can be tuned at diff transformations level.
ex; look up can be optimised by enabling the cache.
aggregator can be optimised by using sorted inout.
filter can be optimised by using it as close as possible
to the sql. so on
Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Where is metadata stored?
What is the difference between informatica 7.0 and 8.0?
Explain the difference between a data warehouse and a data mart?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Explain scd type 3 through mapping.
What are the restrictions of union transformation?
What is incremental aggregation?
Explain lookup transformation is active in informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the data movement modes in informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Can we create a Integration service without a Repository service and vice versa?
What is the command used to run a batch?
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
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me