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
- 5224 Views
- Span Systems, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What are the options in the target session of update strategy transsformatioin?
How do you implement configuration management in Informatica?
i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z
Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?
3 Answers Cap Gemini, Puma, Wipro,
Which is the best place to learn Informatica Powercenter Online Training?
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
performance tuning of Informatica
waht is dataware house
Hey I am net to informatica? Can any one explain me step by step How scd will work ?
What are the joiner caches?
1.why we need to use unconnected transformation? 2.where we can static chach,dynamic chach
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Teradata 
