if the column name in sql override is diff from the column name in source qualifier,what is the impact?
- 5 Answers
- 8818 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / kumarapillaietl@gmail.com
We can write any order under SQL query like Oracle SQL part , but the main thing is we need to maintain that query order in our all mapping flow. Else it's error
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
differences between service based and product based?
What are multi-group transformations?
What is the sequence generator transformation in informatica?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
How to extract sap data using informatica? What is abap? What are idocs?
How do you promote a non-reusable transformation to reusable transformation?
What is aggregate cache in aggregator transformation?
How to generate sequence numbers using expression transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is dimensional table? Explain the different dimensions.
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
What is the difference between a connected look up and unconnected lookup?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is the benefit of partitioning a session?
