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
- 4954 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 have a flat file, want to reverse the contents of the flat file
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation
1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
How to create a mapping ? id date 101 2/4/2008 101 4/4/2008 102 6/4/2008 102 4/4/2008 103 4/4/2008 104 8/4/2008 O/P - shud have only one id with the min(date) How to create a mapping for this
If one flat file contains n number records., we have to load in target from 51 to 100.. how to use expressions in Informatica..?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
What is the difference between procedure and stored procedur?
While migrating the data from one environment to another environment how would you manage the connections?
what is the gap analysis?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
Teradata 
