I have Employee table, 10 cols are connected to next
transformation, only 4 cols are selected in SQL override.
What would be passed to next col.
Answer Posted / dl
few more addition to the above answer......
If you ignore to validate sql query in source qualifier
transformation mapping validates but at workflow level
sessiom fails with as error"variable not in select
list......."
| Is This Answer Correct ? | 19 Yes | 1 No |
Post New Answer View All Answers
How do you load only null records into target? Explain through mapping flow.
What is the use of target designer?
How to create Target definition for flat files?
Reusable transformation and shortcut differences
Parameter and variable differences
what is unit testing?tell me proceedure
State the limitations where we cannot use joiner in the mapping pipeline?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to do unit testing in informatica? How to load data in informatica ?
What is Cognos script editor?
Where are the source flat files kept before running the session?
Differentiate between reusable transformation and mapplet.
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
What is the meaning of up gradation of repository?
Implementation methodology