i have source in oracle 10g,oracle 8i how will u take the
data
from two sources
Answers were Sorted based on User's Feedback
Answer / gm
There is no problem for extracting data from oracle 10g or
8i. using userid/pwd. u can get the data from both sources.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / rams
Will get two sources data through DB link in relational databases
| Is This Answer Correct ? | 0 Yes | 0 No |
where to store informatica rejected data?
what is parameter file?
Which transformation should we use to normalise the COBOL and relational sources?
what is mapping optimization? wat are the techniques for tat
I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.
how the server recognises , if the session fails after loading the 100 records in to the target
Can anyone tell me the new features in Informatica 9 Version?
source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000
State the differences between sql override and lookup override?
What is Code Page Compatibility?