What are the types of data that passes between informatica
server and stored procedure?
Answer / swetha
3 types of data
Input/Out put parameters
Return Values
Status code.
| Is This Answer Correct ? | 4 Yes | 0 No |
get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c
my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
What are the Differences between static cache and dynamic cache?
During the running session, output files are created by informatica server. Enlist few of them.
What are the types of maping in Getting Started Wizard?
How to load data in informatica ?
What is dimensional table?
What did you do in source pre load stored procedure
i have a source table ID NAME SAL 101 A 1000 102 B 2000 103 C 1500 target load should be ID NAME SAL 101 A 1000 101 B 2000 101 C 1500 102 A 1000 102 B 2000 102 C 1500 103 A 1000 103 B 2000 103 C 1500
Let’s say I have more than have record in source table and I have 3 destination table A,B,C. I have to insert first 1 to 10 records in A then 11 to 20 in B and 21 to 30 in C. Then again from 31 to 40 in A, 41 to 50 in B and 51 to 60 in C……So on up to last record.
Hello Everyone,i have one question on sequence generator.i have two targets and the records comes from the source will place in the targets like 1-10 rec in target1 and 11-20 rec in target2,21-30 rec in target1...etc so any one can help me? plz..Thanq in adv.