How to join a Flat and Relational Source without using (Joiner,
Update and Lookup ) transformations... is it possible? if yes i
would like to know how?
Answer Posted / charan
Hi,
I know this is possible but not sure how.. SQ is used for
Homogenius sources. Anyone else please try to get a
positive answer on this one.
Is This Answer Correct ? | 3 Yes | 6 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 development components of informatica have the highest usage?
Differences between connected and unconnected lookup?
Which are the different editions of informatica powercenter that are available?
What are the new features of Power Center 5.0?
What is the difference between source qualifier transformations source filter to filter transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Describe an informatica powercenter?
what are the Methods For Creating Reusable Transformations?
What is a joiner transformation?
how tokens will generate?
While migrating the data from one environment to another environment how would you manage the connections?
How do you update the records with or without using update strategy?
What is main use of mapplet?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?