Interested to Buy Any Domain ? << Click Here >> for more details...
SRC1 -> EXP -> AGGR ->
TGT
SRC2 -> EXP ->
Above is a maaping with two pipeline connected to the taret
TGT. Design wise is this design is correct or not ?
- 6 Answers
- 11075 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / sarthak
If the column structure of the two pipelines are same...we
can use UNION t/f to pass data to single TGT instance
or
if we ll take 2 instances of TGT table.... then It ll be
correct...
else we can't connect two pipelines to single TGT instance
directly
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the new features of informatica 9.x at the developer level?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What if the source is a flat-file?
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
Explain the features of connected and unconnected lookup.
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
list out all the transformations which use cache?
Write the prerequisite tasks to achieve the session partition?
Can anyone tell me the new features in Informatica 9 Version?
How do you use reject loader.
Differences between connected and unconnected lookup?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How are indexes created after completing the load process?
Under what condition selecting sorted input in aggregator may fail the session?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
