In Joiner Transformation, how to identify the master and
detail tables if one is from Oracle and the other is from
Sybase.
Answers were Sorted based on User's Feedback
Answer / priyank
Its completely on a developer's discretion to decide which
source would be the master and which would be the detail.
Generally keeping in mind the performance factor, we tend to
make the source with less number of ports as the master.
Is This Answer Correct ? | 11 Yes | 4 No |
Answer / 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 |
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
without dynamic lookup transformation how to insert new rows and update existing rows?
Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.
Explain how to import oracle sequence into informatica?
How to display null values on a target & non-null values on a target?
What is a joiner transformation and why it is an active one?
what is the hint? how to use it to reduce the query processing in program?
How to Create a folder using pmrep command?
What is main use of mapplet?
what is the difference between static and dynamic
Without source how to insert record to target?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks