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
no rows from the source qualifier transformation.It gives
an error like" query should return exactly 10 fields to
match fields projected from the source qualifier." .
Because number of rows selected in sql override must eqal
to number of rows connected to the next transformation from
source qulifier.
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
What is a repository? And how to add it in an informatica client?
What is flashback table ? Advance thanks
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
wf dont have integration severances how you can run?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What does command task mean?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
How to generate sequence numbers?
permutations of mapplet
complex mapping ur project u r invlve can u explain and give real time example give me ?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a filter transformation?
Describe expression transformation?
Explain the use of aggregator cache file?
How would you copy the content of one repository to another repository?