i having mapping
emp---> sq_emp--->target
using this mapping i have to load dept table values into
target... (condition assume there is no primary and foreign
key relation between emp(table x) and dept (table Y))
Answer Posted / snjsngh15
Based on the constraint based load we can load the data IT means emp table in target t1 and dept in target t2.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do we call shell scripts from informatica?
Explain joiner transformation in informatica
Differentiate between sessions and batches?
How to generate or load values in to the target table based on a column value using informatica etl tool.
What is a predefined event?
As union transformation gives UNION ALL output, how you will get the UNION output?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the new features of informatica 9.x in developer level?
Define the various join types of joiner transformation?
What is transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Can informatica load heterogeneous targets from heterogeneous sources?
how many types of dimensions are available in informatica?
What are the advantages of informatica?