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
- 4997 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
How many transformations can be used in mapplets.
What are the differences between oltp and olap?
Whats there in global repository
How do you manage the Parameter files while migrating your data from one environment to another environment?
How do you load unique records into one target table and duplicate records into a different target table?
How do you load first and last records into target table?
Different qualification between a related rotate toward the sky and isolates look upward?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are the different types of transformation available in informatica.
in reporting we add some new objects,how we get the count of the newly added objects to the report
What do you mean incremental aggregation?
How many numbers of sessions can one group in batches?
Can you generate sequence numbers without using the sequence generator transformation?
What is a transaction control transformation?
What is informatica etl tool?
