Answer Posted / davan
By using sorter t/r have the property like distinct
optation.and also aggregator t/r check group by all ports.
| Is This Answer Correct ? | 2 Yes | 17 No |
Post New Answer View All Answers
What happens when a session fails and you click on recover?
What is domain in terms of informatica?
Can anyone tell me the new features in Informatica 9 Version?
What do you mean by blocking transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is rank index in rank transformation?
How to handle decimal places while importing a flatfile into informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is a transaction control transformation?
-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?
Explain constraint based loading in informatica
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
design of staging area?