Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
Answer Posted / 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 |
Post New Answer View All Answers
What are the types of caches in lookup? Explain them.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What all are steps in up gradation of Informatica server?
What is informatica metadata and where is it stored?
What you know about transaction control transformation?
What do mean by local and global repository?
Could you explain what is enterprise data warehouse?
When do you use sql override in a lookup transformation?
Which are the different editions of informatica powercenter that are available?
What is data movement mode in Informatica and difference between them?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
Performance tuning( what you did in performance tuning)
Partition, what happens if the specified key range is shorter and longer
Enlist the advantages of informatica.
What is a passive transformation?