Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I am working on informatia in a support role. We used
stored procedures in informatica and other than that I
never got a chance to work on PL/SQL,little on Unix
scripts. But I heard people asking about PL/SQL alot. Can
any one let me know how do we use PL/SQL with informatica
and if required what is the knowledge that we need to have
on PL/SQL? Please let me know in detail which would really
help me alot in my career prospectus.
- 1 Answers
- 5094 Views
- Accenture, I also Faced
- E-Mail Answers
Answer / abhinaw prakash
We use Pl/Sql for writing Procedures that we are calling
either in Post SQL or Pre SQL.
If you are working in support best way to start in PL/SQL is
to start with Procedure.Mostly the interviewer ask these only.
| Is This Answer Correct ? | 2 Yes | 0 No |
I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 having Empid,firstname,lastname can i union them using Union t/f?
Which one is better performance wise connected/un-connected lkp?why?
What are the designer tools for creating transformations?
r u done any partitions in ur project?
what is song in infrmatica...?
How you load distinct records into one target and duplicate records into another target?
How the informatica server sorts the string values in Rank transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
Why do we use DSS database for OLAP tools?
Target is zero file and how can you send the email?
why union transformation is active transformation?
Teradata 
