Interested to Buy Any Domain ? << Click Here >> for more details...
if the column name in sql override is diff from the column name in source qualifier,what is the impact?
- 5 Answers
- 9562 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / s
If the col name is diiferent then too the mapping is valid.
The only condition the no of cols in select stmt and no of
cols in source defn should match. The col values will be
assigned to the particular col name in the order which they
mentioned in the select stmt.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How to do unit testing in informatica? How to load data in informatica ?
Why update strategy and union transformations are active? Explain with examples.
How to create or import flat file definition in to the warehouse designer?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is the meaning of decode in informatica?
Which development components of informatica have the highest usage?
How many ways are there to do 'remove duplicate records in informatica'?
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?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How to update or delete the rows in a target, which do not have key fields?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
How to do the error handling of if ur source is flatfiles?
What is joiner change?
What are junk dimensions?
