Two relational tables are connected to SQ Trans,what are
the possible errors it will be thrown?
- 2 Answers
- 7022 Views
- I also Faced
- E-Mail Answers
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
How are indexes created after completing the load process?
what is diff b/t sorter t/r and agg have the option sorter property...
What is expression transformation?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
How will the document be delivered to me?
What is a stored procedure transformation?
What will be the approach?
How do you load only null records into target? Explain through mapping flow.
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Explain the different dimensions.
What is rank transformation?
What the difference is between a database, a data warehouse and a data mart?
Explain in detail about scd type 1 through mapping.
What is DR strategy for Informatica project?
How does a sorter cache works?
