Hi,
I have three tables T1, T2, T3, T4
T1 has a column rec_no
T2 has columns rec_no, prev_rec_no, origin
T3 has columns main_rec_no and sub_rec_no
T4 has columns rec_no, reference
For value of rec_no in T1, I have to fetch prev_rec_no from T2(where rec_no = rec_no in T1) and the...
Hi,
I have three tables T1, T2, T3, T4
T1 has a column rec_no
T2 has columns rec_no, prev_rec_no, origin
T3 has columns main_rec_no and sub_rec_no
T4 has columns rec_no, reference
For value of rec_no in T1, I have to fetch prev_rec_no from T2(where rec_no = rec_no in T1) and the...
I have a source table which stores the data in the following format
CASE_ID DRUG_DE PT_DE
---------------------------------------------------
1 ab;abcd;de;fj;sdgh hj[12];cf[34];sdv[78]
the length of DRUG_DE and PT_DE is variable
And I have two target tables which...
I have a situation wherein my data is stored in a table in the following format...
SOC PT Drug Method Count Date
--------------------------------------------
SOC1 PT1 Drug1 AE 7 01/01/2003
SOC1 PT1 Drug1 Syndrome 6 29/02/2003
SOC1 PT1 Drug1 PRR 4...
Go to services window. Double-click on the Informatica service. Go to Logon tab and select ur account again and give the password(if u have any) and click OK and then run the service again.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.