Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 5 Answers
- 15224 Views
- BirlaSoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / naveen
Above Answer #1 is correct.
Addition of Answer #1 & #2, sql override column order
should be same as source qualifier trnsfn columns.
Regards,
Naveen
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / smith
Only those 4 columns in the sql override will be passed to
the next transformation.
| Is This Answer Correct ? | 2 Yes | 15 No |
How do you load alternate records into different tables through mapping flow?
How will u pas the data with out debugger?
Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer
write a query for how to eliminate the duplicate rows without using distinct?
How to use procedural logic inside infromatica?
Which kind of index is preferred in DWH?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
my source contain data like this cno cname sal 100 rama@gmail.com 1000 200 karuna@yahoo.com 2000 i want load my data to the target is cno cname sal 100 rama 1000 200 karuna 2000 plz send the answer
How to call shell scripts from informatica?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
Why union transformation is an active transformation?
What is mapplet in informatica?
Teradata 
