Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
Answers were Sorted based on User's Feedback
Answer / bidhar
First thing to note is that Both the sources must be
Homogeneous.
Also the Order of the ports in SQ and the order of the
Columns in the select query (if you are using SQL override)
must be same.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / krishna
1.two or more relational tables are with primary key-
foreign key relationships by linking the sources to one
Source Qualifier transformation.
2.the data types of the ports must match.
violation of these two conditions may lead to errors while
joining two tables
| Is This Answer Correct ? | 1 Yes | 1 No |
What do you mean by channel change?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What are the types of groups in Router transformation?
how can u tune u r informatica mapppings
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
What is the Difference between SetVariable and setmaxvariable in informatica?
what is data driven?
Can you copy the session to a different folder or repository?
What are different types of transformations available in informatica?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
when will we go for unconnected lookup transformation in Informatica?