Interested to Buy Any Domain ? << Click Here >> for more details...
Is it any possible to using more than one port in Unconnected
Lookup Transformation( :LKP.LKP_Prod(Prod_GRP
,Prod_DT,Prod_TM) ) Like this? Pls explain...
- 3 Answers
- 7607 Views
- I also Faced
- E-Mail Answers
Answer Posted / rohan
I think the question is can we pass multiple inputs to an
unconnected lookup. If I am correct, the answer is YES.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Which is the t/r that builts only single cache memory?
Explain what is informatica metadata and where is it stored?
What the difference is between a database, a data warehouse and a data mart?
explan ur project architecture?
What do you mean by blocking transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Enlist the various types of transformations.
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?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Performance tuning( what you did in performance tuning)
What is fact table? Explain the different kinds of facts.
What is the difference between a repository server and a powerhouse?
How to generate sequence numbers?
