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
- 9138 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / chandra mouli
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 |
Post New Answer View All Answers
How can we use batches?
What is a repository? And how to add it in an informatica client?
What are the data movement modes in informatica?
What are the types of caches in lookup? Explain them.
What is joiner transformation in informatica?
expain about the tune parameters?
Enlist the differences between database and data warehouse.
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How to Create a folder using pmrep command?
what is index?how it can work in informatica
can you please explain me pre session and post session options?
How to do unit testing in informatica?
