Interested to Buy Any Domain ? << Click Here >> for more details...
One source and 3 targets
1st row-1st target
2nd row-2nd target
3rd row-3rd target
4th row-1ist target how will u do?
- 5 Answers
- 12874 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / kns
source--->source qualifier-->sequence gen(we want to
reset)--->expression(decode)---->router(conditions)--->targets
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a snowflake schema?
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?
Briefly describe lookup transformation?
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?
how to create user defined function (udf) in informatica
What is joiner change?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is meant by incremental aggregation?
What is standalone command task?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Informatica settings are available in which file?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Explain the different kinds of facts.
What is workflow monitor?
Design a mapping to load a target table with the following values from the above source?
