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
- 4996 Views
- Span Systems, I also Faced
- E-Mail Answers
Answer Posted / sukanta
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 ? | 0 Yes | 1 No |
Post New Answer View All Answers
How do you change a non-reusable transformation to reusable transformation?
What is the difference between a repository server and a powerhouse?
Different circumstance which drives informatica server to expel records?
Differences between connected and unconnected lookup?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is the session task and command task?
what is the size of your data warehousing?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Can we create two repositories on same database instance in oracle?
What is informatica?
What is the use of transformation?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Write the unconnected lookup syntax?
What is rank transform?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
