Hi experts, For informatica developer, in real time,
normally how much we use sql and plsql?
- 2 Answers
- 8309 Views
- Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
If your'e well versed with Oracle. In performance point of
view use pre-sql and post-sql or sql query in source
qualifier transformation. If your'e having minimal
knowledge on sql or pl/sql then go for Informatica bcz its
a 3rd party tool which will give solutions in less time
than Normal Oracle.
| Is This Answer Correct ? | 1 Yes | 0 No |
How to elaborate tracing level?
what is fact table?
What you know about transaction control transformation?
in unconnected lookup , what are the other transformations , that can be used in place of that expression transformation ?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
What is the need of building a data warehouse?
What are the guidelines to be followed while using union transformation?
Which development components of informatica have the highest usage?
Whats there in global repository
how the informatica server sorts the strings values in rank transformations?
how do u tune queries?
how to calculate the optimum cache size in aggregator transformation?
Teradata 
