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
What are the new features of Power Center 5.0?
What is workflow? What are the components of workflow manager?
Reusable transformation and shortcut differences
How can one identify whether mapping is correct or not without connecting session?
How can we update a record in the target table without using update strategy?
What is a grid in Informatica?
What is decode in static cache?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is a connected transformation?
what is informatica metadata?
Why do we need informatica?
Name the different lookup cache(s)?
Do you find any difficulty while working with flat files as source and target?
How can we use batches?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N