In Joiner Transformation, how to identify the master and
detail tables if one is from Oracle and the other is from
Sybase.
Answer Posted / naidu+.k
In Joiner Transformation it maintains two sources master and
detail source.Matser Source contains less number of Records
and its supports conditional values and detail source is an
output values stores.
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
How to differentiate between the active and passive transformations?
Describe an informatica powercenter?
How do you handle two sessions in Informatica
Enlist the various types of transformations.
Tell me about Propagate functions in informatica
Plz can any one say me how to get the informatica certification materials and dumps
What is the sql query overwrite in source qualifier in informatica
How to implement security measures using repository manager?
what are the deliverables?in your project?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
-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?
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
what is the -ve test case in your project.
What is joiner transformation in informatica?
What are the different clients of powercenter?