Interested to Buy Any Domain ? << Click Here >> for more details...
How or for what purpose look up transformation would be
useful in Sales or Banking Project?
Please reply!
- 2 Answers
- 5033 Views
- I also Faced
- E-Mail Answers
Answer Posted / raj
For maintaining the complete history we need to look up on
the target table especially in sales and banking projects we
use SCD2 type mappings for maintain the complete history.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Write the prerequisite tasks to achieve the session partition?
How to use pmcmd utility command?
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?
Mention few power centre client applications with their basic purpose?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What is the different lookup cache(s)?
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
How to start a workflow using pmcmd command?
What are mapplets? How is it different from a Reusable Transformation?
What is a node in Informatica?
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?
Where is metadata stored?
How to call shell scripts from informatica?
How can we use mapping variables in informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
