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?
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 to create a non-reusable instance of reusable transformations?
How do you handle two sessions in Informatica
update strategy transformation in informatica
Explain the tuning lookup transformation - informatica
What is an active transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are batches?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are data-driven sessions?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
what is degenerated dimension?
What is domain and gateway node?