What is session task and command task?
What is a standalone command task?
write a query to retrieve the latest records from the table sorted by version(scd)
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?
Mention few advantages of router transformation over filter transformation.
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is sequence generator transformation in informatica?
How do you take back up of repository?
What are the types of maping in Getting Started Wizard?
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?