Interested to Buy Any Domain ? << Click Here >> for more details...
select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
- 5 Answers
- 9133 Views
- Puma, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
In Mapping take two transfermations.
1.aggrigate transfermation
2.filter transfermation.
in aggrigate add one output port is minsal
minsal=MIN(SAL).next in filter condition SAL > minsal.
next link the ports to target.
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / guest
Hi,
Use the lookup on emp table .Override the lookup Query
(select min(sal) from emp. Connect the empno port and min
(sal) port to exp. Fetch all the rows from emp table to
exp, then connect to filter give condition sal> min(sal).
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / cmanojkumar
Hi,
Thanks for your answer.
If we take this in single pipeline it will not allow us to
connect aggregator transformation and source qualifier
transformation to target transformation
Because we can't combine two active transformations to
another transformation.
I would like to know these rules. Can any on tell me why
can't we combine active and active ?
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rudra
SQualifier --> Sql Query -->select * from emp where sal>(select min(sal) from emp) -->Apply-->OK -->connect to TGT table (save it)
## Create wf and ssn then run it
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / chiranjeevi.madam
The above answer is correct. But, the aggregated value should be found in one pipeline and the filter should be in another pipeline both coming from source qualifier or previous t/r.
| Is This Answer Correct ? | 0 Yes | 2 No |
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
how to load dimension table and fact table. plz tell me the steps.
how to run the batch using pmcmd command
If u r giving different parameter file names in workflow and session for a single mapping parameter, then which one will be executed? The one u given in workflow or the one u given in the session?
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
difference between informatica 8.6 and 9
3 Answers Atos Origin, BA Continnum Solutions, Core Logic,
server hot-ws270 is connect to Repository B. What does it mean?
Can you generate sequence numbers without using the sequence generator transformation?
a flat file having 1 laks records. if i want convert excel file what happen. (bcz a exccel sheet having 65536 colums but flat files one lak columns). how to get one laks colums in excel sheet .
can we override a native sql query within informatica? How do we do it?
Teradata 
