Answer Posted / guest
we can not have flat override in any of the Transormation.
We have only sql query here we can use the custom query for
relational sources and we have lookup override is there
here we can sql query for relational sources suppose we
going to lookup on relational table.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
Briefly explain the aggregator transformation?
Explain the etl program with few examples.
what is INFORMATICA TESTING process
Define joiner transformation?
What is session task and command task?
how to load dimension table and fact table. plz tell me the steps.
What do you mean by enterprise data warehousing?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is the session task and command task?
Explain why we use partitioning the session in informatica?
Slowly changing dimensions, types and where will you use them
Explain the different dimensions.
What is an unconnected transformation?