Hi experts, For informatica developer, in real time,
normally how much we use sql and plsql?
- 2 Answers
- 8077 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 |
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is an Integration service in Informatica?
what is the mechanism of the Master-Detail joining condition?
What are your source in project and how you import in informatica? How can i explain abt this?
1 Answers Accenture, Unisoft Infotech,
What is a connected transformation?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
What is substr in informatica?
How to recover the standalone session?
i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486
Teradata 
