Interested to Buy Any Domain ? << Click Here >> for more details...
select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
- 5 Answers
- 8974 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / cmanojkumar
Hi,
Thanks for your answer.
If we take this in single pipeline it will not allow us to
connect aggregator transformation and source qualifier
transformation to target transformation
Because we can't combine two active transformations to
another transformation.
I would like to know these rules. Can any on tell me why
can't we combine active and active ?
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Clarify the utilization of aggregator cache record?
what is Active lock explain
How do you update the records with or without using update strategy?
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
How might you approve all mappings in the archive all the while?
Explain in detail scd type 2 through mapping.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How you can differentiate between connected lookup and unconnected lookup?
Enlist the differences between database and data warehouse.
What is the procedure for creating independent data marts from informatica 7.1?
Describe the impact of several join conditions and join order in a joiner transformation?
How we can create indexes after completing the load process?
What are the new features of informatica 9.x developer?
What is meant by a domain?
can we override a native sql query within informatica? Where do we do it? How do we do it?
