My Source qualifier has empno, sal.
Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET
SAL ------------>TARGET ?
Is this mapping valid or any issues are there if we design
like this?
- 3 Answers
- 5024 Views
- Span Systems, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhishek kumar
if second target is instance means name is different but
same target object than mapping is valid.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / amedela chandra sekhar
mapping is valid but we should not do like this.
| Is This Answer Correct ? | 1 Yes | 0 No |
how i will stop my workflow after 10 errors
have you developed documents in your project? and what documents we develop in realtime?
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
What is surrogate key?
what is the difference between look up and joiner(don't say joiner sopport only = where as look up support non-equijoin).
How to view and Generate Metadata Reports?
what is mapping performence?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
tell me 5 session failure in real time how can you solve that in your project?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?
To import the flat file definition into the designer where should the flat file be placed?
what is data driven in update strategy transformation?
Teradata 
