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
- 15235 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 |
what are surrogate keys?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
what is scd?
My source is this year 01/jun/2014 04/may/2015 09/mar/2017 my desired output is day month ye 01 jun 2014 04 may 2015 09 mar 2017 how do i acheive this
i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression
How will you display "Mr" for male & "Mrs" for female in target table?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
Clarify the utilization of aggregator cache record?
what is incremental aggregation ,with example?
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
Teradata 
