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
- 8937 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is joiner transformation?
What is dynamic cache?
What is lookup transformation?
What is enterprise data warehousing?
What is session task and command task?
What is joiner change?
What is parallel processing in informatica?
Tell me about Propagate functions in informatica
What are the tasks that source qualifier perform?
Explain what are the different versions of informatica?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
How do you load alternate records into different tables through mapping flow?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
