Answer Posted / dilly pratap
metadata comprises of all information about mapping design &
transformation.....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain sessions and how many types of sessions are there?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Explain lookup transformation source types in informatica
without table how to come first record only in oracle?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Slowly changing dimensions, types and where will you use them
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
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
what is informatica metadata?
How are indexes created after completing the load process?
Explain the features of connected and unconnected lookup.
What is session task and command task?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What are different types of transformations available in informatica?
What are the advantages of using informatica as an etl tool over teradata?