Hi experts, For informatica developer, in real time,
normally how much we use sql and plsql?
Answer Posted / ajay konidena
we can't say how much we use .
it is depend on the project requirement so
u must have deep knowledge on both sql,plsql of any DB
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
How to load the data from a flat file into the target where the source flat file name changes daily?
Did u used latest transformations of 8.6.0? for what?
What are the data movement modes in informatica?
What is the commit type if you have a transaction control transformation in the mapping?
What is the Rank index port in Rank transformation?
How big was your fact table
Global and Local shortcuts. Advantages.
Can we override a native sql query within informatica?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the need of etl tools?
Explain the types of lookup transformation?
Mention some types of transformation?
What are the issues you have faced in your project? How did you overcome those issues?
How to join three sources using joiner? Explain though mapping flow.