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
- 5146 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 |
If informatica has its scheduler why using third party scheduler?
What is repository manager?
Explain sessions. Explain how batches are used to combine executions?
What is a mapplet/worklet in informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
Can any one describe what is audit table briefly?how does it look like and what are the columns in it?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
how many repositories can v create in informatica .
3 Answers Cap Gemini, Tech Mahindra,
whats the logic to load the lower level of granularity of data to fact table.
Teradata 
