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
- 5126 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
What is Data Caches size?
What is a snowflake schema?
can we override a native sql query within informatica? How do we do it?
Can we create a Integration service without a Repository service and vice versa?
Explain the difference between mapping parameter and mapping variable?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is exclusive and normal mode for repository services?
How do you load only null records into target?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
During the running session, output files are created by informatica server. Enlist few of them.
How to do unit testing in informatica?
Is it possible to define a single node as a Gateway node as well as worker node?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What the difference is between a database, a data warehouse and a data mart?
What is the use of code page?
