select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
- 5 Answers
- 8136 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 the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
What is the sql query overwrite in source qualifier in informatica
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
What do you understand by term role-playing dimension?
hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???
What are different types of transformations available in informatica?
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
How to load last 10 records of flat file in to the target?
what is the difference between stop and abort
list out all the transformations which use cache?
what is mean by throghput? in informatica
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Teradata 
