Interested to Buy Any Domain ? << Click Here >> for more details...
My Source qualifier has empno, sal. Now my mapping is like
SQ(EMPNO)->AGGR->EXP->TARGET
SAL ------------>TARGET ? means only one source
qualifier has 2 columns like empno, sal. connected to same
target as shown in above mapping.Is this mapping valid or
any issues are there if we design like this?
- 2 Answers
- 5127 Views
- Span Systems, I also Faced
- E-Mail Answers
Answer Posted / guest
It will invalid the mapping because one column value is
going through aggregator(Active)transformation.so in this
case you can't by pass other column direct to target.
in sql query
select sal,max(empno) from emp;
it is a wrong statement,but if you put like this
selct sal,max(empno) from emp group by sal;
works fine
I think you get the solution
Regrads
Sukanta
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is meant by incremental aggregation?
What happens when a session fails and you click on recover?
Write the program through which the records can be updated?
How can we delete duplicate rows from flat files?
What are multi-group transformations?
Performance tuning in UNIX for informatica mappings?
Enlist the advantages of informatica.
Explain the tuning lookup transformation - informatica
How to extract sap data using informatica? What is abap? What are idocs?
Scheduling properties,whats the default (sequential)
Explain the use of aggregator cache file?
Is it possible to create multiple domains on a single Informatica server?
What is the sql query overwrite in source qualifier in informatica
Can anyone tell me the new features in Informatica 9 Version?
