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 is workflow? What are the components of workflow manager?
How to go to the older version for a mapping?
What is an expression transformation?
What do you mean by filter transformation?
Explain your project of banking domian.
Does an informatica transformation support only aggregate expressions?
Mention few power centre client applications with their basic purpose?
Explain the different lookup methods used in informatica?
Where do we use mapping variables in informatica?
What is expression transformation?
In development project what is the process to follow for an etl developer from day1
What are the different lookup cache(s)?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is joiner transformation?