select * from emp where sal>(select min(sal) from emp) how
to implement the same in informatica ?
Answer Posted / 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 |
Post New Answer View All Answers
What are junk dimensions?
Explain what transformation and how many are there in informatica?
State the differences between sql override and lookup override?
IN SCD1, insource we have 10 billion records and in the first day its uploaded successfully and in the second day its taking time to upload because some records it might get update or insert new records. As a developer what will be the better solution for this??
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Define mapplet?
Performance tuning( what you did in performance tuning)
What is a connected transformation?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How to extract sap data using informatica?
What is a router transformation?
my source is junk data how will u remove that junk data by using unix please any one replay me
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How does a sorter cache works?
How you prepared reports for OLAP?