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
- 9143 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 |
what are factless facts? And in which scenario will you use such kinds of fact tables.
Explain pmcmd command usage in informatica
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is a pre-defined event and user-defined event?
What happens if the info. Server doesn't find the session parameter in the parameter file?
what r d pre-requiste for update strategy transformation, and differnce between delete n truncate in target session properties for update strategy
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
without using rank transformation how can we rank items by using some other transformations
i have a wf like wf-->s1-->s2-->s3-->s4 first start s1 later s2 later s3 here my session s3 have to run 3 times later start s4?
Explian the Process of deployment groups in informatica
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
How can we create index after completion of load process?
Teradata 
